Restoring MySQL Data to a Different Destination Server (Cross-Machine Restore)

You can restore a server to the same instance on a different client (also called a cross-machine restore). When a server is restored to another client, the restored data inherits the permissions from the parent directory.

1. From the CommCell Browser, navigate to Client Computers | <Client> | MySQL.

2. Right-click <Instance> on the source client.

3. Click All Tasks, and then click Restore MySql Server.

   The MySql Restore dialog box appears.

4. From the Destination Server list, select the name of the destination client computer where you want to restore.

5. Verify that the Destination Server State of the database is On-Line. If necessary, click Refresh to update the status.

6. Select the Data check box and the Log check box.

7. Select the Recover check box.

8. In the Staging Location box, enter the staging location where the logs will be stored.

9. Click OK.