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
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
All the background activity of creating a backup user etc.
is automatically done by Workbench.
Taking backups and scheduling them is also possible with a
few simple clicks. See the steps and screens below:
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
You can also select the backup directory/image you would
like to use for recovery.
For more details see the workbench documentation.