How can I backup my MySQL Database?

Posted on October 23rd, 2015

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

Leave a Reply