Data Backup with MySQL Workbench version 6.2

Owned by Jonathan Schmale
Last updated: Nov 05, 2018
2 min read

For a quick one time manual backup of your data these steps can be applicable - but this does not support full Unicode characters/content.

This backup method is not recommended for use when setting up replication. 

To create a backup to be used in replication please refer to the notes in Running A Backup Server for Bannister Lake Products with DMan Backup and look for the Create A Master Backup section.

In this section:

STEP 1 - Launch MySQL Workbench

Click on the localhost entry in the list of connections.

STEP 2 - Select Data Export

Select the Export option in the Management list. (If you don't see the management options click the Management tab indicated by the red arrow).

STEP 3 - Select Your Database For Export

Select the database check box that relates to your system on the left


Select all the options shown checked below and enter a folder name to export the db files to:

STEP 4 - Proceed With the Export

Confirm you know the folder name it is going to export to and then click Start Export button (bottom-right)


BL recommends that if you export your database again, create a new folder for the dump output. Each export creates 1 file for each table. If you use the same folder it may overwrite your previous export.