• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. Working with RDS for MySQL
  5. Restoring a DB Instance to a Point in Time

Restoring a DB Instance to a Point in Time

Scenarios

This section describes how to use existing automated backups to restore DB instances to a point in time.

Do not run the reset master command on MySQL DB instances within their lifecycle. Otherwise, an exception may occur when restoring a MySQL DB instance to a specified point in time.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service to go to the RDS console.
  4. On the Instance Management page, click the target DB instance.
  5. On the Backups & Restorations page, click Restore to Point In Time above the backup list.
  6. Select a time range, select or enter a time point within the acceptable range, and select a restoration method. Then, click OK.

    • Create New Instance

      The Create New Instance page is displayed.

      • The DB engine and version of the new DB instance are the same as those of the original DB instance. The database port is 3306 by default.
      • Storage space of the new DB instance is the same as that of the original DB instance by default and must be greater than or equal to that of the original DB instance.
      • Other parameters use the default values and can be modified. For details, see section Creating a DB Instance.
      •  
    • Restore to Original

      Restoring to the original DB instance will overwrite all existing data and the DB instance will be temporarily unavailable.

  7. View the restoration result. The result depends on which restoration method was selected:

    • Create New Instance

      A new DB instance is created using the backup data. The status of the DB instance changes from Creating to Available.

      The new DB instance is independent from the original one. If you need read replicas to offload read pressure, create one or more for the new DB instance.

    • Restore to Original

      On the Instance Management page, the status of the DB instance changes from Restoring to Available.

      A new restoration time range is available. There will be a difference between the new and original time ranges. This difference reflects the duration of the restoration.

    After the restoration, the system will perform a full backup.