Restore Data - MySQL - How To

Topics | How To | Full System Restore | Related Topics

Restore Data to a Point in Time

Recover Data with the Database Online

Recover Logs with the Database Online

Recover Logs with the Database Offline

Recurring Restores of Logs

Cross-Platform Restores from CommCell Console

Restore Data to a Point in Time

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• When you browse and restore your data to a point-in-time, make sure that the point-in-time is later than the browse time selected in the browse options dialog box.

Required Capability: See Capabilities and Permitted Actions

To restore to a point in time:

1. From the CommCell Browser, right-click the instance, click All Tasks, and click Restore Server.
2. From the Restore Options (General) dialog box, select Point in Time and select a Restore Time and Time Zone.
3. Continue your restore.

Recover Data and Bring the Database Online

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To recover data and bring the database online:

1. From the CommCell Browser, right-click the instance, click All Tasks, and click Restore Server.
2. From the Restore (Options) dialog box, click Recover.
3. Continue with your restore.

Recover Logs with the Database Online

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To recover data and logs with the database online:

1. From the CommCell Browser, right-click the instance, click All Tasks, and click Restore Server.
2. From the MySQL Restore (General) dialog box, select Recover. The database will be online for recovery. When you select Recover option, the logs will be applied to the server.
3. Enter the path or click Browse to specify the destination folder path.
4. Continue with your restore.

Recover Logs with the Database Offline

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To recover data and logs with the database offline:

1. From the CommCell Browser, right-click the instance, click All Tasks, and click Restore Server.
2. From the MySQL Restore (General) dialog box, select Do Not Recover. The database will be offline for recovery. When you select Do Not Recover option, you need to specify the path of the Destination Folder to store the logs without applying to the server.
3. Enter the path or click Browse to specify the destination folder path.
4. Continue with your restore.

Recurring Restores of Logs

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To recover data and bring the database online:

1. From the CommCell Browser, right-click the instance, click All Tasks, and click Restore Server.
2. From the MySQL Restore (General) dialog box, select Recurring Restore and then select Recover option for replicating online data from one server to another server.
3. From the MySQL Restore (General) dialog box, select Recurring Restore and then select Do Not Recover option for replicating offline data from one server to another server. Enter the path or click Browse to specify the destination folder path.
4. Continue with your restore.

Cross-Platform Restores from CommCell Console

Perform the following step-by-step procedure to restore the data across same/different versions or platforms from CommCell Console:

From the CommCell Browser, right-click the MySQL server instance on the source client. Select All Tasks and click Restore MySQL Server. Select the name of the client computer with the database you want to restore in the Destination Server from the list. Verify that the Status of the database is displayed as On-Line; if necessary click on the Refresh button to refresh the status. Select the following options to restore and recover the database. Click Browse and select the staging location. Data Logs Recover Click OK.

Back to Top