The point-in-time database restore is useful in the following scenarios:
-
If any unwanted transaction occurs in the database, you can revert the database to a state just before the transaction.
-
If a database fails, you can restore to the state just before the point of failure.
Note
-
When you perform a point-in-time restore for a database, the next scheduled backup for that database converts to a full backup automatically.
-
You cannot perform a point-in-time restore for a MySQL instance configured with MySQL Enterprise backup. Instead, for a MySQL Enterprise backup operation, you can browse and restore to its specific SBT image.
-
From the CommCell Browser, navigate to Client Computers | <Client> | MySQL.
-
Right-click <Instance>, 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 status of the destination server is On-Line. 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 location where the server will be restored.
-
Select Point-in-time, and then set the restore date, time, and time zone to the appropriate values.
-
Click OK.