By default, the data is restored to the same location from where it was backed up, and the existing database files are overwritten. This restore leaves the database in an online state.
Before you start the restore, make sure that the MySQL server is offline. If you attempt to restore while the server is running, the software will notify you to shutdown the server and then resume with the restore:
-
From the CommCell Browser, navigate to Client Computers | <Client> | MySQL.
-
Right-click <Instance> on the source client.
-
Click All Tasks, and then click Restore MySql Server.
The MySql Restore dialog box appears.
-
From the Destination Server list, select the name of the instance where you want to restore.
-
Verify that the Destination Server State of the database is Offline. If necessary, click Refresh to update the status.
-
Select the Data check box and the Log check box.
-
Select the Recover check box.
-
In the Staging Location box, enter the staging location where the logs will be restored.
-
Click OK.