How can I backup my MySQL Database?
You can use PhpMyAdmin to dump the contexts of a database to a *.sql file. You can also use PhpMyAdmin to restore a database from a *.sql file.
In addition to PHPMYADMIN the command line through SSH can be used. The proper format is as follows:
Dump: mysqldump -u username -p databasename > dump.sql
Restore: mysql -u username -p databasename < dump.sql