5.7.2 Online Backup

Sets a backup profile that defines what should be backed up, where the backup should be stored, and when (the frequency) it should be backed up. The main page:

Figure 5.47 Workbench: MySQL Enterprise Backup

Workbench: MySQL Enterprise Backup

The Online Backup page is separated into three sections:

Executing a backup will show a dialog with the progress of the backup operation.

Backup Jobs

Creating a backup job offers several elements. The following information applies to the New Job operation, and Configure Job is used to modify existing jobs.

The Backup Profile Name and its associated Comments field are used to identify the backup job's profile, and this name is listed on the main page.

The New Job scheduling page separates the configuration information into four tabs. The Contents tab defines the schemas and tables to back up, and whether the job is a full or partial backup.

Figure 5.48 Workbench: MySQL Enterprise Backup Configuration: Contents for Full Backups

Workbench: MySQL Enterprise Backup Configuration: Contents for Full Backups

Figure 5.49 Workbench: MySQL Enterprise Backup Configuration: Contents for Partial Backups

Workbench: MySQL Enterprise Backup Configuration: Contents for Partial Backups

The Options tab includes settings to modify the default behavior of the backup process.

By default, the Backup Storage Directory is stored under a sub-folder using the name of the Backup Profile Name in the MySQL Backup Home Directory setting. Additional options include compression and apply-log, and the option to Skip Unused Pages.

Figure 5.50 Workbench: MySQL Enterprise Backup Configuration: Options

Workbench: MySQL Enterprise Backup Configuration: Options

The Schedule tab optionally sets a backup schedule for both full and incremental backups. The schedule uses the Windows Tasks Scheduler on Microsoft Windows, and a cron job on Linux and OS X. It is scheduled using the operating system user that is scheduling the backup, which is typically the MySQL user.

A full backup is slower than the incremental backup that merges with a full backup. A common scenario is to set a full backup as weekly, and an incremental backup as daily. For additional information about backup performance, see Optimizing Backup Performance.

Figure 5.51 Workbench: MySQL Enterprise Backup Configuration: Schedule

Workbench: MySQL Enterprise Backup Configuration: Schedule

The Advanced tab allows you to pass in additional MySQL Enterprise Backup options.

Note

These additional options are not validated.

To recover backups, see Section 5.7.3, “Backup Recovery”.