NetVault Plug-in for MySQL 11.2 - User Guide

Setting restore options

The options displayed on the Options tab depend on whether you use the MySQL Standard/Community option or MySQL Enterprise Backup option.

Setting restore options for MySQL Standard/Community

On the Create Selection Set page, click Edit Plugin Options, and configure the applicable parameters on the Point-in-Time Recovery and Restore Destination tabs. The options displayed depend on the type of backup selected for restore.

To restore either a Full Backup or an Individual Database/Table Copy Only Backup, perform the following steps.

IMPORTANT: When PIT Recovery is enabled on both restored and current Binary Logs, you do not have to determine whether the stop time is located in the restored binary logs or the current binary logs. MySQL automatically stops and starts at the specified time and ignores all the Binary Logs after the specified stop time. You can use both of these options, especially if there is a specific time range in which unwanted transactions occurred. For example, if data that was collected between 11:00 A.M. and 11:15 A.M. on January 29, 2007, was not wanted, select the Enable Recovery Prior to … option and enter “11:00” - “29 Jan 2007” as the Stop Date/Time. In addition, the Enable Recovery After … option would be enabled and “11:15” - “29 Jan 2007” would be input in as the Start Date/Time. As a result, all transactions that occurred between 11:00 and 11:15 on January 29, 2007, are omitted from the restore.

IMPORTANT: You can use both of these options, especially if there is a specific range of positions in which unwanted transactions occurred. For example, if data that was collected between position 805 and 810 contained unwanted transactions, select the Enable Recovery Prior to … option and enter “805” as the Stop Position, and then configure its associated options to call out the Binary Log. In addition, select the Enable Recovery After … option and enter “810” as the Start Position, and then configure its associated options to call out the Binary Log. As a result, all transactions that were logged in the specified Binary Log between 805 and 810 are omitted from the restore. Also, Stop and Start positions must be actual positions listed in a Binary Log, not arbitrary numbers that are greater than the position of the unwanted transaction.

IMPORTANT: Before attempting a relocation restore to a different MySQL Instance, review Recovering to an alternate MySQL Server.

To restore either an Incremental or Differential Backup, perform the following steps.

IMPORTANT: You can use both of these options, especially if there is a specific time range in which unwanted transactions occurred. For example, if data that was collected between 11:00 A.M. and 11:15 A.M. on January 29, 2007, was not wanted, select the Enable Recovery Prior to … option and enter “11:00” - “29 Jan 2007” as the Stop Date/Time. In addition, select the Enable Recovery After … option and enter “11:15” - “29 Jan 2007” as the Start Date/Time. As a result, all transactions that occurred between 11:00 and 11:15 on January 29, 2007, are omitted from the restore.

IMPORTANT: You can use both of these options, especially if there is a specific range of positions in which unwanted transactions occurred. For example, if data that was collected between position 805 and 810 contained unwanted transactions, select the Enable Recovery Prior to … option and enter “805” as the Stop Position, and then configure its associated options to call out the Binary Log. In addition, select the Enable Recovery After … option and enter “810” as the Start Position, and then configure its associated options to call out the Binary Log. As a result, all transactions that were logged in the specified Binary Log between 805 and 810 are omitted from the restore. Also, Stop and Start positions must be actual positions listed in a Binary Log, not arbitrary numbers that are greater than the position of the unwanted transaction.

IMPORTANT: Before attempting a relocation restore to a different MySQL Instance, review Recovering to an alternate MySQL Server.

Setting restore options for MySQL Enterprise Backup

On the Create Selection Set page, click Edit Plugin Options, and configure the applicable parameters on the Options tab:

IMPORTANT: Before you perform a restore, verify that the default NetVault Backup Temporary Directory has sufficient space to accommodate, at least temporarily, all the data included in a Full Backup that was created using the MySQL Enterprise Backup option. You can use the General option to change the default setting to a location that provides sufficient space; you can even use a mapped drive, Network File System (NFS), or SMB mount. In the Navigation pane, click Change Settings, click Server Settings, and then click General in the System and Security section.

Finalizing and submitting the job

The final steps include setting additional options on the Schedule, Source Options, and Advanced Options pages, submitting the job, and monitoring the progress through the Job Status and View Logs pages. These pages and options are common to all NetVault Backup Plug-ins. For more information, see the Quest NetVault Backup Administrator’s Guide.

IMPORTANT: Do not use special characters that are not supported in a filename on the target OS. For example, the characters /,\,*, and @ should not be used on Windows. This requirement is because Plug‑in for MySQL tries to create a folder with the same name as the job title for restoring data temporarily.

TIP: You can also click Choose, and then locate and select the applicable client in the Choose the Target Client dialog box.