1. Run the following command to back-up the database:
mysqldump --add-drop-table -h localhost -u username -p dbname > dbname.sql
2. Run the following command to restore the database:
mysql -h localhost -u username -p dbname < mdmcore.sql
3. If there are any errors, it would be recommended to input a -f entry before the -h entry in the command.
*Note* The /etc/my.conf file should be modified with 'vi' toward the bottom of the file with the following entries: