Restoring Data from a Standby Server

You can restore MySQL data to the master server and the standby server using the block-level restore operation. You can perform this restore operation only on Linux servers.

If the master server is a slave of another server, replication might be affected during the restore operation. To restore data from a standby server, you can also perform the following types of restore operations:

• Table-level restore to the master server

• Table-level restore to the standby server

• Instant Clone Recovery for MySQL Server

Procedure

1. If you are performing a partial replication, perform a block-level backup on the master server.

2. Run a block-level backup operation on the standby server.

   For more information, see Backing Up Data from a Standby Server.

3. Perform a data-only restore operation to the master server.

   For more information, see Restoring a MySQL Instance to a Different Host (Cross-Machine Restore).

4. Perform a data-only restore operation to the standby server.

   For more information, see Restoring a MySQL Instance to the Same Host.

5. From the master server data directory, delete the auto.cnf file.

6. Restart the master server, and then restart the standby server.

7. Set up replication between both the master server and the standby server.

8. Perform a log-only restore operation to the master server.

   For more information, see Restoring a MySQL Instance to a Different Host (Cross-Machine Restore).