Backup
- Open MySQL Workbench.
- Connect to the MySQL Server.
- In the Navigator sidebar, click on Data Export.
- In the newly openned Data Export window...
- Select the database objects to backup.
- Under Options, choose Export to Self-Contained File
- Choose the location [...] for that file.
- We use our OneDrive client folder.
- E.g. OneDrive\Documents\BigFont_Clients\2014-123ST\backups\mysql\ssstudio_wp-2015jan15.sql
- Click Start Export.
- Make sure the export succeeds.
- You'll know if it says "Exported Completed"
- If it doesn't, sometimes trying again a few times will work.
Restore
- Open MySQL Workbench.
- Connect to the MySQL Server.
- In the Navigator sidebar, click on Data Import/Restore.
- In the Data Import/Restore window
- Choose Import from Self-Contained File and select the file [...]