This topic outlines the plug-in’s restore process and describes all the functionality available for use. In addition, Examples of restore scenarios for MySQL Standard/Community and Examples of restore scenarios for MySQL Enterprise Backup offer examples of the various types of restore. Quest recommends that you review these topics to ensure that you understand the functionality available and how it applies to the various types of restore.
When the plug-in performs a Full or Individual Database/Table Copy Only backup, it uses MySQL’s mysqldump utility to stream the SQL statements that are used to create and populate the tables, directly to the backup media. When the plug-in restores one of these forms of backup, the SQL statements are read directly from the backup media, and run automatically.
When the plug-in performs Incremental or Differential Backups, the MySQL Binary Log Index is used to determine which Binary Logs must be copied to the backup media. When these backups are restored, the Binary Logs are restored to a temporary directory, “NETVAULT_HOME/tmp/MySQL”. The mysqlbinlog utility is then used to generate SQL statements for each transaction that was recorded in the Binary Logs. These statements are then run automatically. This process is called “applying Binary Logs.”
Time-based PIT Recovery is typically a one-step process: Restore the Binary Logs from the Incremental or Differential Backup by selecting the Restore and Apply Binary Logs option on the Options tab, and specifying the stop time to be just before the unwanted transaction.
Position-based PIT Recovery is a three-step process:
1 |
Restore the Binary Logs from the Incremental or Differential Backup to a temporary directory on the MySQL Server by selecting the Restore Binary Logs to Temporary Directory to Identify Time or Position option on the Options tab. |
2 |
Use MySQL’s mysqlbinlog utility to identify the specific position of the unwanted transaction. For more information, see the Point-in-Time Recovery section of the MySQL Reference Guide. |
3 |
Restore the same Incremental or Differential Backup again; however, select the Apply Binary Logs from Temporary Directory restore option, and specify the stop position that exists right before the unwanted transaction. |
Be aware of the following restrictions for restoring a TTS Backup:
For more information, see https://dev.mysql.com/doc/mysql-enterprise-backup/4.0/en/restore-use-tts.html.
A standard restore with Plug‑in for MySQL includes the steps outlined in the following topics.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center