The options displayed on the Options tab depend on whether you use the MySQL Standard/Community option or MySQL Enterprise Backup option.
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.
1 |
Use the following guidelines to select the applicable options on the Point-in-Time Recovery tab. |
• |
Perform PIT Recovery on Current Binary Logs: Select this option to perform a Point-in-Time form of restore of the selected data objects using the Binary Logs currently residing in the MySQL Binary Log directory on the MySQL Server. After this option is enabled, all remaining options on this tab are made available. |
• |
Point In Time Type: In this section, select the applicable form of PIT Recovery: |
• |
Time Based PIT (default selection): Select this option to restore the selected data to a specified time, described in Time-based Point-in-Time (PIT) Recovery. With this option selected, the Time Based PIT Details section is made available. |
• |
Position Based PIT: Select this option to restore the selected data to a specific stop position that exists right before an unwanted transaction, described in Position-based Point-in-Time (PIT) Recovery. With this option selected, the Position Based PIT Details section is made available. |
• |
Time Based PIT Details: If you selected Time Based PIT, select the applicable options: |
• |
Enable Recovery Prior to Erroneous/Bad SQL Statement(s): To restore all transactions that occurred before the unwanted transaction, select this option. If you select only this option, all transactions that occurred after the time specified here are lost. Using a 24-hour time format, specify the applicable date and time in the associated Stop Date/Time fields. |
• |
Enable Recovery After Erroneous/Bad SQL Statement(s): To restore all transactions that occurred after to the unwanted transaction, select this option. If you select only this option, all transactions that occurred before the time specified here are lost. Using a 24-hour time format, specify the applicable date and time in the associated Start Date/Time fields. With a specific start date and time selected, you can also set a stop date and time for transactions: |
• |
None (default selection): Leave this option selected if you want to recover all transactions that occurred after the specified date and time. |
• |
Specific Date: If you only want to include transactions that occurred during a specific range of time, select this option, and enter the applicable stop time in the associated fields, using the 24-hour time format. |
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. |
• |
Position Based PIT Details: If you selected Position Based PIT, select the applicable options: |
• |
Enable Recovery Prior to Erroneous/Bad SQL Statement(s): To restore all transactions that occurred before the unwanted transaction, select this option. If you select only this option, all transactions that occurred after the position specified here are lost. This option offers the following associated options: |
• |
Stop Position: Enter the position in the Binary Log before the unwanted transaction. For example, if the position of the unwanted transaction is 805, enter 804. |
• |
Binary Log Containing Stop Position: Use this list to select the specific Binary Log that contains the stop position specified in the Stop Position. If a different file is desired or the applicable file is not listed, select OTHER, and enter the applicable filename in the text box. |
• |
Enable Recovery After Erroneous/Bad SQL Statement(s): To restore all transactions that occurred after the unwanted transaction, select this option. If you select only this option, all transactions that occurred before the position specified here are lost. This option also offers the following associated options: |
• |
Start Position: Enter the position in the Binary Log after the unwanted transaction. For example, if the position of the unwanted transaction is 805, enter 806. |
• |
Binary Log Containing Start Position: Use this list to select the specific Binary Log that contains the start position specified in the Start Position. If a different file is desired or the applicable file is not listed, select OTHER, and enter the applicable filename in the text box. |
• |
Stop Position: None (default selection)– Leave this option selected if you want all transactions recovered that occurred after the specified Start Position. |
• |
Stop Position: Specific Position: If you only want to include transactions that occurred between a specific range of Binary Log positions, select this option. Enter the applicable stop position, and select the applicable Binary Log in the Binary Log Containing Stop Position list — if a different file should be used, select OTHER, and enter the filename. Only transactions that occurred between the positions specified in the Start Position and the Specific Position fields are included in 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. |
2 |
Use the following guidelines to select the applicable options on the Restore Destination stab. |
• |
Restoring to the same MySQL Instance: If the restore targets the same instance that was originally backed up, leave these fields blank. NetVault Backup uses the values set in the Configure dialog box. For more information, see Configuring the plug-in. |
• |
Restoring to a different MySQL Instance: If you intend to relocate a restore of the selected data to a different instance, enter the applicable information in the Username and Password fields that allows access to the new instance. Additionally, enter the NetVault Backup name established for the new instance in the Instance Name field — this name is the name established as the MySQL Instance Name in the Configure dialog box ; for more information, see Configuring the plug-in. |
To restore either an Incremental or Differential Backup, perform the following steps.
1 |
Use the following guidelines to select the applicable options on the Point-in-Time Recovery tab. |
• |
Perform PIT Recovery: Select this option to perform a Point-in-Time form of restore of the selected data items. After this option is enabled, all remaining options on this tab are made available. |
• |
Restore and Apply Binary Logs (Used when Time or Position is already known): If the time or position at which corruption occurred is known, select this option to restore the Binary Logs from the backup device and apply the recorded transactions in one restore job. If you also want to perform a PIT Recovery on the Binary Logs currently residing in the MySQL Binary Log directory, select the Include Current Binary Logs check box. This process is performed after any Binary Log transactions that were saved in the Incremental or Differential Backup are restored and applied. |
• |
Restore Logs to Temporary Directory to Identify Time or Position: To restore only the Binary Logs associated with the selected Incremental or Differential Backup to a temporary directory on the MySQL Server, that is, “NETVAULT_HOME/tmp/MySQL/,” select this option. This option lets you use the mysqlbinlog utility to review the recovered logs to identify the time and position of the data corruption. |
• |
Apply Binary Logs from Temporary Directory: If you previously used the Restore Logs to Temporary Directory to Identify Time or Position option, and you used the mysqlbinlog utility to identify the corrupted data that is to be omitted from the restore, select this option. This process applies the Binary Logs that were restored to the temporary directory. If you also want to perform a PIT Recovery on the Binary Logs currently residing in the MySQL Binary Log directory, select the Include Current Binary Logs check box. This process is performed after the Binary Log transactions that exist in the temporary directory are restored and applied. |
• |
Point In Time Type: With the Perform PIT Recovery option enabled, select the applicable form of PIT Recovery: |
• |
Time Based PIT (default selection): Select this option to restore the selected data to a specified time (described in Time-based Point-in-Time (PIT) Recovery). With this option selected, the Time Based PIT Details section is made available. |
• |
Position Based PIT: Select this option to restore the selected data to a specific stop position that exists right before an unwanted transaction, described in Position-based Point-in-Time (PIT) Recovery. With this option selected, the Position Based PIT Details section is made available. |
• |
Time Based PIT Details: If you selected Time Based PIT, select the applicable options: |
• |
Enable Recovery Prior to Erroneous/Bad SQL Statement(s): To restore all transactions that occurred before the unwanted transaction, select this option. If you select only this option, all transactions that occurred after the time specified here are lost. Using a 24-hour time format, specify the applicable date and time in the associated Stop Date/Time fields. |
• |
Enable Recovery After Erroneous/Bad SQL Statement(s): To restore all transactions that occurred after the unwanted transaction, select this option. If you select only this option, all transactions that occurred before the time specified here are lost. Using a 24-hour time format, specify the applicable date and time in the associated Start Date/Time fields. With a specific start date and time selected, you can also set a stop date and time for transactions: |
• |
None (default selection): Leave this option selected if you want to recover all transactions that occurred after the specified date and time. |
• |
Specific Date: If you only want to include transactions that occurred during a specific range of time, select this option. Enter the applicable stop time in the associated fields, using the 24-hour time format. |
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. |
• |
Position Based PIT Details: If you selected Position Based PIT, select the applicable options: |
• |
Enable Recovery Prior to Erroneous/Bad SQL Statement(s): To restore all transactions that occurred before the unwanted transaction, select this option. If you select only this option, all transactions that occurred after the position specified here are lost. This option offers the following associated options: |
• |
Stop Position: Enter the position in the Binary Log before the unwanted transaction. For example, if the position of the unwanted transaction is 805, enter 804. |
• |
Binary Log Containing Stop Position: Use this list to select the specific Binary Log that contains the stop position specified in the Stop Position. If a different file is desired or the applicable file is not listed, select OTHER, and enter the applicable filename in the text box. |
• |
Enable Recovery After Erroneous/Bad SQL Statement(s): To restore all transactions that occurred after to the unwanted transaction, select this option. If you select only this option, all transactions that occurred before the position specified here are lost. This option also offers the following associated options: |
• |
Start Position: Enter the position in the Binary Log after the unwanted transaction. For example, if the position of the unwanted transaction is 805, enter 806. |
• |
Binary Log Containing Start Position: Use this list to select the specific Binary Log that contains the start position specified in the Start Position. If a different file is desired or the applicable file is not listed, select OTHER, and enter the applicable filename in the text box. |
• |
Stop Position: None (default selection): Leave this option selected if you want all transactions recovered that occurred after the specified Start Position. |
• |
Stop Position: Specific Position: If you only want to include transactions that occurred between a specific range of Binary Log positions, select this option. Enter the applicable stop position, and select the applicable Binary Log in the Binary Log Containing Stop Position list; if a different file should be used, select OTHER, and enter the filename. Only transactions that occurred between the positions specified in the Start Position and the Specific Position fields are included in 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. |
2 |
Use the following guidelines to select the applicable options on the Restore Destination tab. |
• |
Restoring to the same MySQL Instance: If the restore targets the same instance that was originally backed up, leave these fields blank. NetVault Backup uses the values set in the Configure dialog box. For more information, see Configuring the plug-in. |
• |
Restoring to a different MySQL Instance: If you intend to relocate a restore of the selected data to a different instance, enter the applicable information in the Username and Password fields that allows access to the new instance. Additionally, enter the NetVault Backup name established for the new instance in the Instance Name field — this name is the name established as the MySQL Instance Name in the Configure dialog box ; for more information, see Configuring the plug-in. |
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. |
• |
Full Restore: Select the applicable options. |
• |
Restore, Extract Raw Full Backup… (default selection): Select this option to restore a Full Backup to a temporary location that mirrors the MySQL Server data repository directory hierarchy. This option assumes that you know which backup to restore; if you do not, you can use the next two options. |
• |
Restore Full Backup Image to Temp File: Select this option if you need to list the contents of the backup to determine which backup you need to run the next option. |
• |
Extract Raw Full Backup from Temp File…: Select this option after you have used the results the preceding option, Restore Full Backup Image to Temp File, to determine which backup you need to restore. This option restores the Full Backup to a temporary location that mirrors the MySQL Server data repository directory hierarchy. |
• |
Shutdown MySQL Server and Copy Back…: Select this option when you are ready to shut down the MySQL Server and copy the restored contents from the temporary location back to the original location. |
• |
Validate Backup Image: To instruct the plug-in to run the validate command against the extracted data, select this check box. |
• |
List Backup Image: To list the contents of the backup in the output log, select this check box. |
• |
Incremental Restore: Select the applicable options. |
• |
Restore, Extract Incremental Backup… (default selection): Select this option to restore an Incremental Backup. This option assumes that you know which backup to restore; if you do not, you can use the next two options. |
• |
Restore Incremental Backup Image to Temp File: Select this option if you need to list the contents of the backup to determine which backup you need to run the next option. |
• |
Extract Incremental Backup from Temp File…: Select this option after you have used the results the preceding option, Restore Incremental Backup Image to Temp File, to determine which backup you need to restore. |
• |
Shutdown MySQL Server and Copy Back…: Select this option when you are ready to shut down the MySQL Server and copy the restored contents from the temporary location back to the original location. |
• |
Validate Backup Image: To instruct the plug-in to run the validate command against the extracted data, select this check box. |
• |
List Backup Image: To list the contents of the backup in the output log, select this check box. |
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 Dell NetVault Backup Administrator’s Guide.
1 |
2 |
In Job Name, specify a name for the job if you do not want to use the default setting. |
3 |
In the Target Client list, select the machine on which you want to restore the data. |
TIP: You can also click Choose, and then locate and select the applicable client in the Choose the Target Client dialog box. |
4 |
Use the Schedule, Source Options, and Advanced Options lists to configure any additional required options. |
5 |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center