Overview
This article mainly describes the recovery methods for data loss in RDS.
Detail
Alibaba Cloud reminds you that:
- Before you perform operations that may cause risks, such as modifying instance configurations or data, we recommend that you check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.
- You can modify the configurations and data of instances including but not limited to Elastic Compute Service (ECS) and Relational Database Service (RDS) instances. Before the modification, we recommend that you create snapshots or enable RDS log backup.
- If you have authorized or submitted sensitive information such as the logon account and password in the Alibaba Cloud Management Console, we recommend that you modify such information in a timely manner.
Perform the following steps to restore data.
Data loss caused by DML misoperation
Use the data tracing function of DMS to retrieve data. For more information, see data tracing and rollback.
Data loss caused by DDL misoperations
- Use RDS individual databases or tables for restoration. For more information, see restore individual databases or tables for an RDS for MySQL instance.
- If you do not enable the individual database or table restoration feature, you can clone instances to restore individual databases or tables. For more information, see recover MySQL data.
Application scope
- ApsaraDB RDS instance