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.

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.

Restrictions

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

Procedure

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.