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
- Log in to the management console.
- Click
in the upper left corner and select a region.
- Click
in the upper left corner of the page and choose Databases > Relational Database Service.
- On the Instances page, click the target instance name to go to the Overview page.
- In the navigation pane on the left, choose Backups & Restorations.
- Click the Database Backups tab. Locate a backup and click Restore in the Operation column.
- Select the databases to be restored and click Next: Confirm.
Figure 1 Database-level restoration
- 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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot