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.
