Updated on 2025-06-24 GMT+08:00

Restoring Databases from Database-Level Backups

Scenarios

You can restore a database to its original instance from a database-level backup. After the restoration is successful, a new database and tables are generated on the instance and they have timestamps appended to their names. You can rename the tables or manage the table data as required.

Constraints

  • Any database or table whose name contains any Chinese characters cannot be restored.
  • Database- or table-level restoration is not supported for databases or tables that contain JSON virtual columns.
  • A maximum of 50 databases can be restored for an instance at a time.

Prerequisites

After the restoration, new databases and tables will be generated in the original DB instance. Ensure that the DB instance has sufficient storage space for them.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, click the target instance name to go to the Overview page.
  5. In the navigation pane on the left, choose Backups & Restorations.
  6. Click the Database Backups tab. Locate a backup and click Restore in the Operation column.
  7. Select the databases to be restored and click Next: Confirm.

    Figure 1 Database-level restoration

  8. On the displayed page, confirm the information and click Submit.

    • On the Instances page, check that the DB instance status is Restoring. During the restoration, workloads are not interrupted.
    • After the restoration is successful, new databases and tables are generated on the instance and they have timestamps appended to their names. You can rename the tables or manage the table data as required.