When data is accidentally deleted or corrupted, use the instance restoration feature to recover backup data from an ApsaraDB MyBase for MySQL instance. Restoration always creates a new instance — the original instance is not modified.
Prerequisites
Before you begin, make sure that:
-
The original instance is in the Running state and is not locked
-
The original instance has no ongoing migration tasks
-
If you plan to restore by point in time, log backup is enabled on the original instance
Restore modes
ApsaraDB MyBase for MySQL supports two restore modes:
| Mode | How it works | When to use |
|---|---|---|
| By Time | Restores from a log backup at a specified point in time, accurate to the second. The point in time must fall within the log retention period. | Recover to a specific moment, such as just before an accidental deletion |
| By Backup Set | Restores from a complete backup set. | Recover a full, consistent snapshot when second-level precision is not required |
Restore an instance
-
Log on to the ApsaraDB for MyBase console.
-
In the upper-left corner of the Dedicated Clusters page, select the region where the original instance is deployed.
-
In the left-side navigation pane, click Dedicated Clusters. Find the dedicated cluster and click Details in the Actions column.
-
In the left-side navigation pane, click Instances. Then open the Restore Database panel using one of the following methods:
-
Method A: Find the original instance. In the Actions column, click More > Restore Database.
-
Method B: Find the original instance and click Details in the Actions column. On the instance details page, click Backup and Restoration, then find the backup you want to restore and click Restore in the Actions column.
-
For instances using a local SSD: click
, then click Restore. 
-
For instances using an enhanced SSD (ESSD): click Restore directly.
-
-
-
In the Restore Database panel, configure the following parameters:
Parameter Description vSwitch The vSwitch for the new instance. If no vSwitches are available, click the button below the drop-down list to create one. Restore Mode Select By Time or By Backup Set. Restore Point Available when Restore Mode is By Time. Specify the point in time to restore to. By Backup Set Available when Restore Mode is By Backup Set. Specify the point in time at which the backup set was generated. Instance Type The instance type for the new instance. Storage Capacity The storage capacity for the new instance. -
Click OK.
A new instance is created with the restored data. The original instance is not affected.