Restore data

更新时间:
复制 MD 格式

This topic describes how to restore the data of an instance that runs on an ApsaraDB for MyBase host to a new instance. If you restore data to the original instance, data loss may occur.

Prerequisites

Before you begin, make sure that you have:

  • A backed-up instance. For instructions, see Back up data

  • A restore target: either a point in time within the log backup retention period, or a specific backup set

Restore a MySQL or PostgreSQL instance

  1. Log on to the ApsaraDB for MyBase console.

  2. In the upper-left corner, select the region where you want to restore instance data.

  3. In the left-side navigation pane, click Clusters.

  4. Find the dedicated cluster that contains your instance, then click Details in the Actions column.

  5. In the left-side navigation pane, click Instances.

  6. Find the instance you want to restore, then choose More > Restore Database in the Actions column.

  7. Configure the following parameters.

    ParameterDescription
    vSwitchThe vSwitch to connect the new instance to. To view vSwitch details, go to the Virtual Private Cloud (VPC) console.
    Restore ModeThe restore method. Select By Time to restore to a point in time, or By Backup Set to restore from a specific backup.
    Restore PointThe point in time to restore to, accurate to the second. Required when Restore Mode is By Time. The target time must fall within the log backup retention period. To view or change the retention period, see Back up data.
    By Backup SetThe backup set to restore from. Required when Restore Mode is By Backup Set.
    Instance TypeThe specifications of the new instance.
    Storage CapacityThe storage capacity of the new instance.
  8. Click OK.

    If the storage type of the instance is Local SSD, complete the payment on the page that appears.

What's next

Restore Redis data

For instructions on how to restore Redis data, see Backup and recovery.