Restoring MySQL Data from a Standby Server

You can restore MySQL data to the master server and the standby server using an IntelliSnap 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 operations:

• Redirect restore

• Instant Clone Recovery for MySQL Server

Procedure

1. If you are performing a partial replication, take a snap backup from the master server.

2. Run an IntelliSnap 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 and Recovering an Entire MySQL Instance.

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

   For more information, see Restoring and Recovering an Entire MySQL Instance.

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 and Recovering an Entire MySQL Instance.