Restore MySQL Database Tables and Instances from a Block-Level Backup

You can perform a table restore and a full instance restore to the same host or a different host from MySQL block-level backups.

When you restore a table to a specific failure point, you must restore tables to a user-defined auxiliary instance. To restore individual database tables, select the tables from the list of database tables in a tree view and restore them to a destination location.

Note

Best Practice: Include the parent tables with all dependent tables so that the reference constraints remain intact. To do this, during the browse and restore operation, right-click table and select an option to either include dependent tables or referenced tables.

You can use one of the following methods to restore the MySQL tables and instances:

Restoring MySQL Tables

Restoring MySQL Full Instances

Restoring from a Standby Server

Important

At the time of a restore operation, the log files are downloaded to the staging directory. Ensure that the staging directory has sufficient space to hold the log files. For example, if your database size is 20GB, the size of the log files generated will be 20GB. Therefore, the staging directory size must be at least 20GB.

Loading...