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
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 replica with the data from a source server, or to clone a database for reporting purposes.
See Chapter 5, Recovering or Restoring a Database for instructions on restoring databases.