WebHostingPeople Blog

How Can We Help?

How can I backup my MySQL Database?

You are here:

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

Post Your Comment