Restoring a MySQL Instance to a Different Host (Cross-Machine Restore)

You can restore objects to a different database on the destination client (cross-machine). A cross-machine restore is one in which the restore destination is a different client from the client where the backup was taken. This restore leaves the database in an online state.


Do not use this method to perform a partial restore on databases. For instructions to perform a partial restore, see Restoring MySQL Tables to a Different Host (Cross-Machine Restore).

Before You Begin

Check whether you meet the following requirements:

  • The source and destination clients have the same version of MySQL Server.

  • The destination client meets the MySQL system requirements for block-level backup.

  • MySQL Agent and MediaAgent are installed on the destination client.

  • Verify that the MySQL server is offline. If you attempt to restore while the server is running, the software will notify you to shut down the server and then resume with the restore. The data part of the backup is then restored to the data directory of the server. Then, as part of the Transaction Log restore, the server is brought online and the logs are applied.


  • Revert restore operation is supported only for hardware snap engines.

  • When you perform a revert restore operation, make sure that the volume is not in use.


  1. From the CommCell Browser, expand Client Computers > Client > MySQL > Instance.

  2. Right-click the subclient, and then select Browse and Restore.

  3. On the Browse and Restore Options dialog box, click View Content.

    Optional: If your destination client has a MediaAgent installed, from the Advanced Options tab, you can select the Linux MediaAgent installed on your destination client.

    For more information, see Browse and Restore Data.

  4. From the Browse window, select the data that you want to restore, and then click Recover All Selected.

    The MySql Restore dialog box is displayed.

  5. From the Destination list, select the name of the destination client where you want to restore the MySQL instance.

  6. Click OK.


  • You can also perform a full instance restore from the instance level by either selecting Restore MySql Server or Browse and Restore:

  • If you select Restore MySql Server, from the Data Path tab of the Advanced Restore Options dialog box, select a Linux MediaAgent before running the restore operation.

  • If you select Browse and Restore, from the Advanced Options tab of the Browse and Restore Options dialog box, select a Linux MediaAgent before running the restore operation.

  • The file permissions for the staging directory must be set to 777.

  • Do not use root directory as a staging location.

  • Verify that you have selected a Linux MediaAgent before running the restore operation.