Data Backup with MySQL Workbench version 6.2
- Jonathan Schmale
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.
|
|
