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:
Procedure
-
If you are performing a partial replication, perform a block-level backup on the master server.
-
Run a block-level backup operation on the standby server.
For more information, see Backing Up Data from a Standby Server.
-
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).
-
Perform a data-only restore operation to the standby server.
For more information, see Restoring a MySQL Instance to the Same Host.
-
From the master server data directory, delete the auto.cnf file.
-
Restart the master server, and then restart the standby server.
-
Set up replication between both the master server and the standby server.
-
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).