FAQ

Updated at:

This page answers common questions about data restoration for ApsaraDB RDS for MySQL instances. For an overview of available restoration methods, see Overview of data restoration methods.

How do I restore data using a binary log backup file?

Use the database and table restoration feature or the full data restoration feature and set Restore Mode to By Time. Point-in-time recovery (PITR) automatically matches the full backup with the binary log (binlog) files within the required time range, so you do not need to manually download or concatenate multiple binlog files. When you restore to the original instance, the restored data is stored in a new database whose name is the original database name suffixed with _backup by default. Table names remain the same as the original tables, and the existing data is not overwritten. For step-by-step instructions, see Restore full data of an ApsaraDB RDS for MySQL instance.

How do I restore a deleted database?

Use the restoration feature for individual databases and tables. See Restore individual databases and tables for instructions.

If your RDS instance does not support individual database and table restoration, restore the full data to a new RDS instance, verify it, and then migrate the data back to the original instance. See Restore full data of an ApsaraDB RDS for MySQL instance for the restore step.

How do I restore deleted data?

Use the data tracking feature of Data Management (DMS) to find and roll back the deleted data:

  1. Track data changes in the relevant time range using the data tracking feature.

  2. Generate SQL rollback statements from the tracked changes.

  3. Apply the rollback statements using the data change feature.

For the tracking and rollback steps, see Use the data tracking feature of DMS to restore the data of an ApsaraDB RDS for MySQL instance. For the apply step, see Change regular data.

How do I restore RDS data to an existing instance or a self-managed database?

Important

You cannot restore a downloaded backup file directly to an existing RDS for MySQL instance. Instead, restore to a new temporary instance first, verify the data, and then transfer what you need to the target destination.

Choose a method based on where you want the data to end up:

Restore to the original RDS instance

Method When to use
Method 1: Restore to a new RDS instance, verify the data, then migrate some or all data back to the original instance You need to selectively recover specific databases or tables
Method 2: Use the restoration feature for individual databases and tables to restore directly Your instance supports individual database and table restoration
Method 3: Use Database Backup (DBS) to create a logical backup, then restore using the logical backup file. See Restore a MySQL database from a logical backup You prefer a logical backup-based approach

Restore to another existing RDS instance

Method When to use
Method 1: Restore to a new RDS instance, verify the data, then migrate to the target instance General-purpose restore and transfer
Method 2: Use Database Backup (DBS) to create a logical backup, then restore using the logical backup file. See Restore a MySQL database from a logical backup You prefer a logical backup-based approach

Restore to a self-managed database

Method When to use
Method 1: Restore to a new RDS instance, verify the data, then migrate to the self-managed database General-purpose restore and transfer
Method 2: Use Database Backup (DBS) to create a logical backup, then restore using the logical backup file. See Restore a MySQL database from a logical backup You prefer a logical backup-based approach
Method 3: Download a backup file and restore from it directly. First, download the backup files. Then pick the guide that matches your backup type: use a physical backup file, use a logical backup file, or use a CSV or SQL file You have already downloaded the backup and want to restore locally

Am I charged for data restoration?

  • Full data restoration: Restoring to a new RDS instance incurs charges for that instance. You can view the price estimate during instance creation.

  • Individual database and table restoration: Fees may apply. See the Pricing section for details.