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.

You can perform a table level restore for partial restores with individual tables, but not full instance. For example, a MySQL instance has one database and one table. Table level restores are not supported if you select the table, the database, and eventually the instance.

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...