How to Backup and restore a MySQL Database for Mobility Suite

Products

• Mobility Suite

Issue/Introduction

 

Resolution

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:

max_allowed_packet=64M

innodb_log_file_size=128M