This topic describes how to restore the data of an instance that runs on a MyBase for MySQL host to another instance. Data loss may occur if you restore the data to the original instance.

Prerequisites

The original instance must meet the following requirements:

  • The instance is in the Running state and is not locked.
  • The instance does not have ongoing migration tasks.
  • If you want to restore data from a log backup generated at a specified point in time, make sure that the log backup feature is enabled for the original instance.
  • If you want to restore data from a backup set, make sure that the original instance must have at least one complete physical backup. For more information, see Perform automatic backups and manual backups for an ApsaraDB RDS for MySQL instance.

Note

  • The destination instance must have the same whitelist, backup, and parameter configuration as the original instance.
  • The data in the new instance must be the same as the data in the specified backup set or log backup file of the original instance.
  • The account information in the new instance must be the same as the account information that is indicated by the specified backup set or log backup file of the original instance.

Procedure

  1. Log on to the ApsaraDB for MyBase console.
  2. In the upper-left corner of the RDS Dedicated Clusters page, select the region where the instance for which you want to restore data is deployed.
    Select a region
  3. In the left-side navigation pane, click Clusters. On the page that appears, find the dedicated cluster that you want to manage and click Details in the Actions column.
  4. In the left-side navigation pane of the cluster details page, click Instances. Find the instance for which you want to restore data and choose More > Restore Database.
  5. In the Restore Database (previously Clone Instance) panel, configure the parameters.
    Parameter Description
    VSwitch Specify the vSwitch to which the new instance is connected. If no vSwitches are available, click the button below the drop-down list to create a vSwitch.
    Restore Mode
    • By Time: You can restore data from a log backup generated at a specified point in time. The specified point in time must be within the specified log retention period. The time is accurate to the second. For more information about how to view or change the retention period of log backups, see Perform automatic backups and manual backups for an ApsaraDB RDS for MySQL instance.
    • By Backup Set: You can restore data from a specified backup set. You can restore data only from a backup set that is generated from a physical backup. You cannot restore data from a backup set that is generated from a logical backup.
    Restore Point If you select By Time for Restore Mode, you must specify a point in time.
    By Backup Set If you select By Backup Set for Restore Mode, you must specify the point in time at which the backup set from which you want to restore data was generated.
    Type Code The specifications of the new instance.
    Storage Capacity The storage capacity of the new instance.
  6. Click OK.