How to Backup MySQL

[unemployment]

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.

[jacek]

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.