BetterPHP

I need to take a backup of my database and I wasn't sure what the best methods for a good backup are. There seem to be a lot of choices in phpmyadmin and I haven't done a back up through it in a very long time. Any suggestions or tips? I'd like to be able to back it up to also be able to use the database locally as well.

You can use the export tab to create a load of SQL code that will create the same databases, tables and data.

Or if you are looking for an automated thing, have a look at the "mysqldump" command.