6.7 MySQL Enterprise Backup Interface

6.7.1 General Requirements

6.7.2 Online Backup

6.7.3 Backup Recovery

Commercial releases of MySQL Workbench include a graphical interface that enables you to use MySQL Enterprise Backup (MEB) functionality to safeguard your MySQL data from unexpected loss. The specific options may vary, depending on the version of MySQL and MySQL Workbench that you have installed. For more information, see Section 6.7.1, “General Requirements”.

There are two MySQL Enterprise Backup operations available from MySQL Workbench:

• Online backup.  Establishes a backup profile to define what should be backed up, where the backup should be stored, and when (the frequency) MySQL should be backed up. With an active MySQL connection tab open, select MySQL Enterprise Backup from the Server menu to view the Online Backup page in the current tab.

• Backup recovery.  Restores the MySQL server to a specific point in time, typically by restoring a backup that was created by the Online Backup feature in MySQL Workbench. With an active MySQL connection tab open, select Backup Recovery from the Server menu to view the Recovery page in the current tab.

The MySQL Enterprise Backup configuration is located on the MySQL server, and not locally within MySQL Workbench. This information includes the MySQL Enterprise Backup configuration backup profiles, job scheduling, backup operations, and data. The backup and restore operations can be scheduled to executed with (or without) MySQL Workbench running.

For information comparing the different methods to import and export data using MySQL Workbench, see Section 6.5, “Data Export and Import”.