MEB integration with Workbench
By SanjayM on Nov 25, 2013
The latest versions of MySQL Workbench starting from version 6 have the capability to integrate with MySQL Enterprise Backup (MEB).
Though all the functionality of MEB is not supported, it is still a great tool to begin your backup and get your backup setup in minutes. Workbench also provides the additional capability to be able to schedule your backups.
The sections below illustrate the setup and usage of the Workbench UI to be able to setup and execute backup using MEB.
This is a quick start guide to setup, make a backup and do a recovery using MySQL Workbench and MEB.
The installation of WB and MEB is not discussed; it should be a simple automated install for both packages.
Workbench now comes with a new MySQL enterprise options in its navigator menu on the left. You need to click the Online Backup option to get to the screens for MEB.
Workbench not only allows you to create the setup, but also verifies that the setup options that you have given are correct with a green check mark.
All the background activity of creating a backup user etc. is automatically done by Workbench.
- Click “Settings”
- Path to MEB Executable e.g. in linux browse to “/opt/mysql/meb-3.9/bin”
- Create a backup directory
- Select a password for user for backup
Taking backups and scheduling them is also possible with a few simple clicks. See the steps and screens below:
Taking a full/incremental backup
- Press “OK”/ “create backup profile” to go to main backup screen
- Press “Execute Now”
- Press “Execute Now (incremental)
- Go to your backup directory to check
- Click “Configure Job”
- Click on “Schedule” tab
- Set the time of the day for full backup and incremental backup as desired
Creating a Compressed backup
- Click “Options” tab
- Click Compressed
- Click “Contents” tab
- Select the database
- Select the tables from the database
Recovery is also as simple as backup. Please do be careful since the recovery will be done on the existing instance of the server. If you recover from an old backup, all changes since that backup may be lost.
The simplest recovery using the latest backup is illustrated below:
- Goto “Backup Recovery” on the Navigator
- Ensure profile is correct and “use latest backup" is checked
- Click “Next
You can also select the backup directory/image you would like to use for recovery.
For more details see the workbench documentation.