Document Center

All Products

Document Center

ApsaraDB RDS:Overview of data restoration methods

Last Updated:Dec 16, 2022

This topic describes the methods that you can use to restore the data of an ApsaraDB RDS for MySQL instance.

Scenarios


Connection scenario		Method
Restore the data of an RDS instance that is accidentally released		Locked Instances: Log on to the ApsaraDB RDS console and go to the Locked Instances page. In the top navigation bar, select the region where the RDS instance resides. If you can find the RDS instance on the Locked Instances page, you can rebuild the RDS instance. Backups: If the RDS instance uses local SSDs and you specified the Backup Retention Policy After Release parameter on the Backup Settings tab to configure the RDS instance to retain backup files, log on to the ApsaraDB RDS console, go to the Backup for Deleted Instances tab of the Backups page, download the required backup files, and then restore the data of the RDS instance.
Restore the data that is accidentally deleted from an RDS instance		Restore full data of an ApsaraDB RDS for MySQL instance Restore individual databases and tables of an ApsaraDB RDS for MySQL instance Use the data tracking feature of DMS to restore the data of an ApsaraDB RDS for MySQL instance Download the backup file. Then, restore data to the self-managed database from the backup file. For more information, see Download the backup files of an ApsaraDB RDS for MySQL instance and Restore the data of an ApsaraDB RDS for MySQL instance from a physical backup file to a self-managed MySQL database, Restore the data of an ApsaraDB RDS for MySQL instance from a logical backup file to a self-managed MySQL instance, or Restore the data of an ApsaraDB RDS for MySQL instance to a self-managed MySQL instance by using a CSV file.
View the data in the data backup files of an RDS instance View the data that exists at a specified point in time in an RDS instance		You can use the native flashback feature to view the data that exists at a specified point in time in the RDS instance. For more information, see Native flashback. This method requires a short period of time to restore data. If logical backups are created by Database Backup (DBS) for the RDS instance, query the data from the generated logical backup files. For more information, see Query data from DBS-generated logical backup files. This method requires a short period of time to restore data. Create a DBS sandbox instance to obtain the data backup files of the RDS instance and restore the data of the RDS instance from the data backup files. For more information, see Create a sandbox instance for the emergency disaster recovery of an ApsaraDB RDS for MySQL database. Then, view the data of the RDS instance. This method requires a short period of time to restore data. Restore the full data of the RDS instance or only the data from the specified individual databases and tables of the RDS instance. For more information, see Restore full data of an ApsaraDB RDS for MySQL instance or Restore individual databases and tables of an ApsaraDB RDS for MySQL instance. Then, view the data of the RDS instance. Compared with the previous two methods, this method requires a longer period of time to restore data.
Migrate the data of an RDS instance Restore the data from the backup files of an RDS instance to an on-premises database or to the cloud	Migrate or restore the data of an RDS instance to the cloud	Migrate the most recent data of the RDS instance. For more information, see the following topic: Migrate data from a self-managed MySQL database to an ApsaraDB RDS instance Restore the data that exists at a specified point in time Native flashback Migrate the historical data of the RDS instance: Restore the data from the backup files of the RDS instance to an on-premises database. Then, migrate the data from the on-premises database to an RDS instance. For more information, see Migrate data from a self-managed MySQL database to an ApsaraDB RDS for MySQL instance. Use DBS to create a logical backup. Then, restore the data from the generated logical backup file to an RDS instance on the cloud. For more information, see Restore a MySQL database from a logical backup.
	Migrate or restore the data of an RDS instance to an on-premises database	Migrate the most recent data of the RDS instance. For more information, see the following topic: Migrate data from an ApsaraDB RDS for MySQL instance to a self-managed MySQL database Migrate the historical data of the RDS instance: If logical backups are created by DBS for the RDS instance, restore the data from the generated logical backup files to the on-premises database. For more information, see Restore a MySQL database from a logical backup. If you restore the data of the RDS instance from the backup files that are downloaded from the ApsaraDB RDS console, follow the instructions that are provided in Restore the data of an ApsaraDB RDS for MySQL instance from a physical backup file to a self-managed MySQL database or Restore the data of an ApsaraDB RDS for MySQL instance from a logical backup file to a self-managed MySQL instance. Restore the incremental data by using binary log files. For more information, see Restore data by point-in-time through RDS MySQL backups for user-created databases.
	Migrate the data of an RDS instance to a different RDS instance	Migrate the most recent data of the RDS instance: Migrate data between ApsaraDB RDS for MySQL instances Migrate the historical data of the RDS instance: If logical backups are created by DBS for the RDS instance, restore the data from the generated logical backup files to the destination RDS instance. For more information, see Restore a MySQL database from a logical backup. If only default backups are created for the RDS instance, restore the full data of the RDS instance or only the data from the specified individual databases and tables of the RDS instance to the same RDS instance or to a new RDS instance. For more information, see Restore full data of an ApsaraDB RDS for MySQL instance or Restore individual databases and tables of an ApsaraDB RDS for MySQL instance. Then, migrate the data to the destination RDS instance.

More scenarios

How helpful was this page?

$!csrfToken.hiddenField

What might be the problems?

More suggestions?