Documentation Home
MySQL Enterprise Backup 3.12 User's Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.1Mb
PDF (A4) - 1.2Mb
HTML Download (TGZ) - 176.2Kb
HTML Download (Zip) - 201.7Kb


1.5 Overview of Restoring a Database

To initiate the restore process, you run the mysqlbackup client with the copy-back or the copy-back-and-apply-log command. You can restore all the data for a MySQL server with multiple databases, each containing multiple tables. For backups created using transportable tablespace (TTS) (that is, backups created with the --use-tts option), you can also choose to restore selected databases, tables, or both.

To repair a problem such as data corruption, you restore the data back to its original location on the original server machine. You might restore to a different server machine or a different location to set up a new replication slave with the data from a master server, or to clone a database for reporting purposes.

See Chapter 5, Recovering or Restoring a Database for instructions on restoring databases.