Create a backup using MySQL Workbench

Create a backup using MySQL Workbench

1. Connect to your MySQL database.
2. Click Server on the main tool bar.
3. Select Data Export.
4. Select the tables you want to back up.
5. Under Export Options, select where you want your dump saved. By default, it will save to your Documents folder in a subfolder titled dumps.
6. Click Start Export.

Note:

You may get a message about a mismatch between your mysqldump.exe version and the MySQL Server version. You can update your local MySQL version or continue.

7. You now have a backup version of your site. Store this content securely in a manner consistent with your MySQL schema content's data classification.

Load a MySQL dump from MySQL Workbench

To load a MySQL dump file after a database failure or corruption:

1. Connect to your MySQL database.
2. Click Server on the main tool bar.
3. Select Data Import.
4. You should see a link to the default dump folder, typically your Documents folder in a subfolder titled dumps.
5. Click the ... and navigate to where your MySQL backup file is located, select the backup you want to load, and click OK.
6. The schema names in your dump should appear on the left-hand side, at the bottom. Select the schemas that need to be restored.
7. Select Start Import on the bottom right.

#viastudy