5.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 5.7.2, “Online Backup”

The Backup Recovery wizard allows you to restore backups from folders, image files, and backup profiles created by Section 5.7.2, “Online Backup”.

Figure 5.52 Workbench: Backup Recovery: Main page

Workbench: Backup Recovery: Main page

In our example, we will restore a full backup that was created by MySQL Workbench Online Backup. After choosing the "backup (full)" profile that we created earlier, the next page lists each table that will be updated:

Note

We unchecked Show System Schemas the option, which is enabled by default.

Figure 5.53 Workbench: Backup Recovery: Table View

Workbench: Backup Recovery: Table View

Clicking Next > will open the Restore wizard. We then clicked Restore > to execute the restoration process, and toggled the message logs in our example below:

Figure 5.54 Workbench: Backup Recovery: Restore

Workbench: Backup Recovery: Restore