Welcome to Shaun Luttin's public notebook. It contains rough, practical notes. The guiding idea is that, despite what marketing tells us, there are no experts at anything. Sharing our half-baked ideas helps everyone. We're all just muddling thru. Find out more about our work at bigfont.ca.

Backup and Restore a MySQL Database with MySQL Workbench

Tags: mysql, mysql-workbench

Backup

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

Restore

  1. Open MySQL Workbench.
  2. Connect to the MySQL Server.
  3. In the Navigator sidebar, click on Data Import/Restore.
  4. In the Data Import/Restore window
    1. Choose Import from Self-Contained File and select the file [...]