How can I backup my MySQL Database?

Posted at October 23, 2015 at 8:07 am by InterServer Staff

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

0.00 avg. rating (0% score) - 0 votes

You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply