Restoration Solutions
If your database is damaged or mistakenly deleted, you can restore it from backups.
Restoring a Mistakenly Deleted Instance
- RDS moves unsubscribed yearly/monthly instances and deleted pay-per-use instances to the recycle bin. You can rebuild an instance that was deleted up to 7 days ago from the recycle bin.
- You can restore a deleted instance from its retained manual backups. For details, see Restoring a DB Instance from Backups.
Restoring Mistakenly Deleted or Modified Data of a DB Instance
Solution |
Category |
Storage Type |
Restoration Time Point |
Scope |
Restore To |
Time Required |
||||
Cloud SSD |
Extreme SSD |
Point in Time When a Backup Was Generated |
All Databases and Tables |
Certain Databases and Tables |
New Instance |
Original Instance |
Existing Instance Other than the Original Instance |
|||
Restoring an entire instance |
Restoration from backups |
√ |
√ |
x |
√ |
x |
√ |
√ |
√ |
Depending on how much data there is in the instance |
Point-in-time recovery (PITR) |
√ |
√ |
√ |
√ |
x |
√ |
√ |
√ |
Depending on how much data there is in the instance |
|
Restoring databases and tables |
Standard restoration |
√ |
√ |
√ |
x |
√ |
x |
√ |
x |
Depending on how much data there is in the instance and in the databases and tables |
Fast restoration |
√ |
√ |
√ |
x |
√ |
x |
√ |
x |
Depending on how much data there is in the databases and tables |
Restoring or Migrating Data to an RDS for MySQL Instance
- You can restore data to an RDS for MySQL instance from backups. For details, see Restoring Data to RDS for MySQL.
- You can migrate data to an RDS for MySQL instance using Data Replication Service (DRS), mysqldump, or Data Admin Service (DAS). For details, see Migration Solution Overview.
Restoring or Migrating Data to a Self-Managed MySQL Database
- You can restore data to a self-managed MySQL database from backups. For details, see Restoring Data to an On-Premises MySQL Database.
- You can migrate data to a self-managed MySQL database using DRS. For details, see From MySQL to MySQL.
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