Restoring Data to a DB Instance
Scenarios
You can use an automated or manual backup to restore data to the point in time when the backup was created. The restoration is at the instance level.
Procedure
- Log in to the management console.
- Click in the upper left corner and select a region and a project.
- Click in the upper left corner of the page, choose .
- Select the backup to be restored using either of the ways:
In the navigation pane on the left, click Backups. On the Backups page, select the backup to be restored and click Restore in the Operation column.
On the Instances page, click the instance name to go to the Basic Information page. On the Backups page, select the backup to be restored and click Restore in the Operation column.
- Select a restoration mode. Currently, the backup can be restored to a new DB Instance or the original DB Instance.
Figure 1 Restoring an instance from a backup
- Select Create New Instance and click OK. On the Create New Instance page, configure parameters and click Next.
- The region, DB engine and version of the new instance are the same as those of the original instance and cannot be changed.
- The default database port is 3306.
- Other settings are the same as those of the original DB instance by default and can be modified.
- Restore to Original: Click Next.
Data on the original instance will be overwritten and the original DB instance will be unavailable during the restoration.
Figure 2 Restoring to the original instance
- Select Create New Instance and click OK. On the Create New Instance page, configure parameters and click Next.
- View the restoration results.
- Create New Instance: After the creation is complete, the instance status changes from Creating to Available. The new instance is independent from the original one and includes the data before the backup was created. If you want to offload read pressure from the primary node, create one or more read replicas for the new instance.
A full backup is triggered after the new instance is created.
- Restore to Original: When the instance status changes from Restoring to Available, the restoration is complete.
- Create New Instance: After the creation is complete, the instance status changes from Creating to Available. The new instance is independent from the original one and includes the data before the backup was created. If you want to offload read pressure from the primary node, create one or more read replicas for the new instance.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.