MySQL Enterprise Backup is a MySQL Enterprise Feature that is separate from MySQL Workbench. For more information about its functionality, see the MySQL Enterprise Backup documentation at http://dev.mysql.com/doc/mysql-enterprise-backup/en. MySQL Workbench provides an interface to MySQL Enterprise Backup, as described in the following documentation. In addition to having MySQL Enterprise Backup installed on your host, the following general requirements also apply:
Managing both local and remote MySQL instances is available on Linux and Mac OS X, and managing local MySQL instances is available on Microsoft Windows. Remote management is configured using SSH Remote Management.
A MySQL connection with a root user.
The MySQL server configuration file path must be set and correct for the MySQL connection.
The user running MySQL Workbench must be a sudoer (Linux / OS X) that is able to execute the MySQL Enterprise Backup binary.
Additionally, the sudo user must keep the
HOME environment variable when executing
system commands, which means adding the following to
And the Prerequisites set in the Settings tab are:
A path to the MySQL Enterprise Backup executable. MySQL Enterprise Backup is available via eDelivery or My Oracle Support (MOS). MySQL Workbench attempts to locate the MySQL Enterprise Backup executable, so check the path and adjust it accordingly.
The path to the Backup Home Directory, where backup profiles and data is stored. This can be created from within Workbench from the Settings tab.
The MySQL account for the Backup Process. The available actions depends on the current state of this set up, with options including:
Create MEB Account: Available if a backup user does not already exist.
Change Password: Available if a backup user does exist.
Fix Grants for MEB...: Available if
the user's privileges are invalid, which alters the user
by adding the
ON *.* privileges.
The Settings tab:
If any of the requirements are not met, then an error will be generated when attempting to use MySQL Enterprise Backup features.