6.7.3 Backup Recovery

The Backup Recovery wizard is used to recover MySQL Enterprise Backup backups. For more information about creating MySQL Enterprise Backup backups using MySQL Workbench, see Section 6.7.2, “Online Backup”.

The Backup Recovery wizard enables you to restore backups from folders, image files, and backup profiles created by Section 6.7.2, “Online Backup”. Before you can restore a MySQL instance from a backup to a target server, you must first delete all files inside the data directory of that server.

With an active MySQL connection tab open, click Server and then Backup Recovery from the menu to view the Recovery screen in the current tab. The following figure shows an example recovery session.

Figure 6.29 Workbench: Backup Recovery: Start

Content is described in the surrounding text.

  • Backup Profile: Choose from the available MySQL Enterprise Backup profiles on your system.

  • Backup Image File: Opens the system's file browser; choose a backup image file to restore.

  • Backup Folder: Opens the system's file browser; choose a backup folder to restore.

In the following figure, the example session restores a full backup profile that was created by MySQL Workbench Online Backup. After choosing the "FullBackup" profile that we created earlier, use the next page to review its upcoming restoration.

Figure 6.30 Workbench: Backup Recovery: Profile

Content is described in the surrounding text.

Optionally, click View Backup Content to view the backup contents for the restoration (see the figure that follows for an example).

Figure 6.31 Workbench: Backup Recovery: Contents Table View

Content is described in the surrounding text.

Note

The Show System check box toggles internal schemas from view, schemas such as the internal performance_schema and mysql tables.

Clicking Next opens the Restore wizard. The example next uses Restore to execute the restoration process and to toggle the message logs as shown in the following figure.

Figure 6.32 Workbench: Backup Recovery: Restore

Content is described in the surrounding text.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.