How to Backup and Restore a MySQL Database Using mysqldump

How to Backup a MySQL Database With mysqldump

mysqldump -u userNameWithPrivileges -p databaseName > outputFileName.sql

How to Restore a mysqldump Backup

mysql -u userNameWithPrivileges -p database < outputFileName.sql

* Replace “userNameWithPrivileges” with the username of a MySQL account that can read/write to the database being backed up / restored.

MySQL logo