Help Center > > User Guide> Working with RDS for MySQL> Backups and Restorations> Restoring a Table to a Specified Point in Time

Restoring a Table to a Specified Point in Time

Updated at: May 26, 2020 GMT+08:00

Scenarios

To ensure data integrity and reduce impact on the original instance performance, the system restores the full and incremental data at the selected time point to a temporary DB instance, automatically exports the tables to be restored, and then restores the tables to the original DB instance. The time required depends on the amount of data to be backed up and restored on the DB instance. Please wait. Restoring tables will not overwrite data in the DB instance. You can select tables to be restored.

Constraints

  • This function is supported only for MySQL DB instances.
  • MySQL 8.0 DB instances do not support table-level point-in-time restore (PITR).
  • During the table-level point-in-time restore, DB instances and read replicas cannot be rebooted or deleted, and their instance specifications cannot be modified.

Prerequisites

After the table is restored, a new table will be generated in the DB instance. Ensure the DB instance has sufficient storage space for the generated table.

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 RDS. The RDS console is displayed.
  4. On the Instance Management page, click the target DB instance.
  5. Choose Backups & Restorations in the navigation pane on the left. On the Full Backups page, choose More > Restore Table above the DB instance list. Alternatively, on the Binlog Backups page, click Restore Table above the DB instance list.
  6. Set the restoration date, time range, time point, and tables to be restored, and click Next: Confirm.

    • To facilitate your operations, you can search for the tables and belonged databases to be restored.
    • After the restoration is complete, new tables with timestamps as suffixes are generated in the DB instance. You can rename the new tables.
    • The new table name must be unique, consist of 4 to 64 characters, start with a letter, and end with a letter or digit. Only letters, digits, and underscores (_) are allowed.
      Figure 1 Restoring tables

  7. If you have enabled the operation protection function, click Send Code in the displayed Identify Verification dialog box and enter the obtained verification code. Then, click OK.

    Second authentication is required to improve the security of your account and cloud product. For details about how to enable operation protection, see the Identity and Access Management User Guide.

  8. On the displayed page, confirm the information and click Submit.
  9. On the Instance Management page, the DB instance status is Restoring. During the restoration process, services are not interrupted.

    You can also view the progress and result of restoring tables to a specified point in time on the Task Center page.

    After the restoration is successful, you can manage data in the tables as required.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel