How can I backup my MySQL Database?

Last modified: July 29, 2020
You are here:
Estimated reading time: < 1 min

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

Was this article helpful?
Dislike 0
Views: 6