Data Backup with MySQL Workbench version 5.x

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 they do 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

Under Server Administration double click on the LOCALHOST entry in the list.


STEP 2 - Select Data Export

Select the Data Export and Restore option from the Task and Object Browser


STEP 3 - Select Your Database For Export

Select the database check box that relates to your system on the left and assign a folder for the export option on the right. This will export a series of files representing your data.

Incorporate the date of your backup into the folder name as you will end up having multiple exports with subsequent upgrades and backups.



STEP 4 - Proceed With the Export

Click on the Start Export button at the bottom right and the backup will begin. Depending on the amount of data, it may take several minutes.


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 will overwrite your previous export.