MySQL Workbench

6.7.1 General Requirements

MySQL Enterprise Backup (MEB) is a MySQL Enterprise feature that is separate from MySQL Workbench. For more information about its functionality, see the MySQL Enterprise Backup documentation. MySQL Workbench provides an interface to MySQL Enterprise Backup, as described in this section.

In addition to having MySQL Enterprise Backup installed on the target server, the following general requirements also apply:

Prerequisite Settings

To set the following prerequisites, click Settings from the main screen (either Online Backup or Restore):

  • A path to the MySQL Enterprise Backup executable. MySQL Enterprise Backup is available with eDelivery or My Oracle Support (MOS). MySQL Workbench attempts to locate the MySQL Enterprise Backup executable based on the version MySQL server in use, so check the path and adjust it accordingly. For example:

    • For MySQL 8.0, use the MySQL Enterprise Backup version with the same version number as the server.

    • For MySQL 5.7, use MySQL Enterprise Backup 4.1.

    • For MySQL 5.6, use MySQL Enterprise Backup 3.12.

  • The path to the Backup Home Directory, where backup profiles and data is stored. This can be created from within Workbench from Settings.

  • 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 account by adding the RELOAD, SUPER, and REPLICATION CLIENT ON *.* privileges.

The following figure shows an example of the prerequisites.

Figure 6.26 Workbench: MySQL Enterprise Backup Settings

Content is described in the surrounding text.

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

Uninstalling Workbench

The following list of notes describes the behavior of MySQL Enterprise Backup operations after you remove MySQL Workbench:

  • Uninstalling Workbench 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 macOS.

  • Uninstalling Workbench does not remove the MySQL Enterprise Backup master related configuration file, the configuration files generated for each defined profile, or the MySQL backups.