This topic describes how to restore data from a MySQL or SQL Server backup file to a new RDS instance.

Scenarios

This topic describes how to restore data to an apsaradb for RDS instance by using a backup client. You can restore data to a new RDS instance by using the backup client.

Note
  • Apsaradb RDS for PostgreSQL or PPAS does not support restoring data by using physical backup files to an apsaradb RDS for PPAS instance. You need to use a client to perform logical backup before releasing the instance. You need to use the pg_dump function to restore data to a new RDS instance when restoring data. For more information, see Migrate an on-premises PostgreSQL database to ApsaraDB RDS PostgreSQL by using the psql command tool.
  • Currently, RDS for MariaDB does not allow you to download backup files.

Restore data in an apsaradb RDS for MySQL instance

You can recover data to the new RDS instance by following these steps:
  1. Restore the backup data of an apsaradb for RDS instance to an on-premises database. For more information, see Use a physical backup file to restore an ApsaraDB RDS for MySQL instance to a user-created MySQL database or Restore data from logical backup files of an ApsaraDB RDS MySQL instance to an on-premises database.
  2. Use data transmission service (DTS) to migrate the local database to the new RDS instance. For more information, see Migrate data from a user-created MySQL database to an ApsaraDB RDS for MySQL database.

SQL Server Recovery method

You can restore data to a new RDS instance by migrating data from the OSS instance to the cloud. For more information, see Migrate full backup data to ApsaraDB RDS SQL Server 2012, 2016, or 2017or Migrate data from an on-premises database to ApsaraDB RDS SQL Server 2008 R2 using full backup files.