Backup and restore MySQL database

The following is a generic procedure parting from the default scenario of having the database located in the local server using MySQL. The user should take this procedure only as a reference and adapt it to the particular scenario of its organization.

The process of backup-restore in this example will be done using MySQL Workbench tool.

Backup

1. Stop Franson NMEA Service and Franson.SysMonitor.Service from Site Admin > Service > Start/Stop or in Windows, Control Panel\All Control Panel Items\Administrative Tools > Services.

2. Open MySQL Workbench.

3. Select the DB instance.

mceclip0.png

4. Type the root user password

mceclip1.png

Note: if you don't have the root user password read here how to restore it.

5. Click on Data Export and choose the following parameters.

mceclip2.png

6. Now click on Export Progress, then on Start Export.

mceclip3.png

Note: if you export a backup from MySQL5 using MySQL Workbench 8, you might see this warning, simply click on Continue Anyway.

mceclip0.png

7. Wait until the process is done. Make sure you read the logs in case something has not been backed up or triggered an error.

mceclip4.png

Restore

If you restore the database in another server, make sure you install MySQL and MySQL Workbench in the destination.

1. Install and open MySQL Workbench in the destination server.

2. Follow steps 3 and 4 from Backup above.

3. Click on Data Import/Restore

4. Select Import from Self-Contained File and choose the path of your backup from step 7 above.

mceclip5.png

5. Click on Import Progress then Start Import.

mceclip6.png

6. Wait until the import has finished

mceclip7.png

The backup-restore of the database is now complete.