All Products
Search
Document Center

ApsaraDB for MyBase:Restore data

Last Updated:Mar 29, 2024

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

The data of your instance is backed up.

Background information

For more information about ApsaraDB for MyBase, see What is ApsaraDB for MyBase?

Restore the data of an instance that runs MySQL or PostgreSQL

  1. Log on to the ApsaraDB for MyBase console.

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

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

  4. Find the dedicated cluster in which you want to restore instance data and click Details in the Actions column.

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

  6. Find the instance for which you want to restore data and choose More > Restore Database in the Actions column.

  7. Configure the parameters described in the following table.

    Parameter

    Description

    VSwitch

    The vSwitch to which the new instance is connected. You can log on to the Virtual Private Cloud (VPC) console to view the detailed information about the vSwitch.

    Restore Mode

    • By Time: You can restore data to a point in time within the specified log backup retention period. The time is accurate to the second. For more information about how to view or change the log backup retention period, see Back up data.

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

    Restore Point

    The point in time to which you want to restore the data. You must specify this parameter if Restore Mode is set to By Time.

    By Backup Set

    The backup set that is used to restore data. You must specify this parameter if Restore Mode is set to By Backup Set.

    Instance Type

    The specifications of the new instance.

    Storage Capacity

    The storage capacity of the new instance.

  8. Click OK.

    Note

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