All Products
Search
Document Center

ApsaraDB for MyBase:Restore the data of an instance

Last Updated:Jul 14, 2023

You can use the instance restoration feature of ApsaraDB MyBase for MySQL to restore backup data to a new instance. This topic describes how to restore the data of an ApsaraDB MyBase for MySQL instance.

Prerequisites

Your 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.

Procedure

  1. Log on to the ApsaraDB for MyBase console.

  2. In the upper-left corner of the Dedicated Clusters page, select the region where the original instance is deployed.

    Select a region
  3. In the left-side navigation pane, click Dedicated Clusters. On the page that appears, find the dedicated cluster that you want to manage and click Details in the Actions column. Then, the Dedicated Cluster Information appears.

  4. In the left-side navigation pane, click Instances. You can use one of the following methods to restore data:

    • Find the original instance. In the Actions column, click More and then click Restore Database. Restore the data of an ApsaraDB MyBase for MySQL instance

    • Find the original instance, and click Details in the Actions column. On the page that appears, click Backup and Restoration.

      • Scenario 1: The original ApsaraDB MyBase for MySQL instance uses a local SSD. On the Backup and Restoration page, find the backup that you want to restore. In the Actions column, click 按钮 and then click Restore. Restore the data of an instance that uses a local SSD

      • Scenario 2: The original ApsaraDB MyBase for MySQL instance uses an enhanced SSD (ESSD). On the Backup and Restoration page, find the backup that you want to restore. In the Actions column, click Restore. Restore data

  5. In the Restore Database panel, configure the parameters. The following table describes 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.

    • By Backup Set: You can restore data from a specified backup set.

    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.

    Instance Type

    Specify the instance type for the new instance.

    Storage Capacity

    Specify the storage capacity for the new instance.

  6. Click OK.