6.7.1 General Requirements

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:

  • A recent version of MySQL Enterprise Backup. The MySQL Enterprise Backup support policy is to support the current GA version of MySQL Enterprise Backup, and the major version before that. This dictates the minimum MySQL Enterprise Backup version required by MySQL Workbench, which is the major version before the current GA release.

  • Managing both local and remote MySQL instances is available on Linux and 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 /etc/sudoers:

    env_keep +="HOME"

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 RELOAD, SUPER, and REPLICATION CLIENT ON *.* privileges.

Uninstallation notes

  • The MySQL Workbench uninstallation process does not remove the associated MySQL Enterprise Backup backup tasks. To stop the scheduled backups, edit the related "Task Scheduler" entries on Windows, or remove the associated cron jobs on Linux and OS X.

  • The MySQL Workbench uninstallation process does not remove the MySQL Enterprise Backup master related configuration file, the configuration files generated for each defined profile, nor the MySQL backups.

The Settings tab:

Figure 6.32 Workbench: MySQL Enterprise Backup Settings

Workbench: MySQL Enterprise Backup Settings

If any of the requirements are not met, then an error will be generated when attempting to use MySQL Enterprise Backup features.

Download this Manual
PDF (US Ltr) - 14.7Mb
PDF (A4) - 14.7Mb
EPUB - 12.8Mb
HTML Download (TGZ) - 12.7Mb
HTML Download (Zip) - 12.8Mb
User Comments
Sign Up Login You must be logged in to post a comment.