MySQL Enterprise Backup 3.12.0 (MEB) introduces a new feature for restoring an InnoDB table from a backup. Now it is possible to rename the table during restore. This is useful when the user wants to restore a table from a backup without overwriting the existing version of the table in the database.
The following example illustrates how the renaming feature could be used. Suppose that the DBA has deleted three rows from a table T1 by mistake and he now wishes to get them back from a backup. He wants to leave the database online and to restore the 3 deleted rows from a TTS backup (a backup created with the --use-tts option) that contains the table T1. He can do this with this feature in three steps:
- He restores with MEB the table T1 from a TTS backup renaming
it to T2.
- He uses MySQL client to issue SQL statements to …