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.
Apsaradb RDS for PostgreSQL does not support restoring data by using physical backup files to an apsaradb RDS 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 data from a self-managed PostgreSQL database to an ApsaraDB RDS for PostgreSQL instance by using pg_dump and pg_restore.
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:
Restore the backup data of an apsaradb for RDS instance to an on-premises database. For more information, see 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.
Use data transmission service (DTS) to migrate the local database to the new RDS instance. For more information, see Migrate data from a self-managed MySQL database to an ApsaraDB RDS for MySQL instance.
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 the full backup data of a self-managed SQL Server instance to an ApsaraDB RDS instance or Migrate the full backup data of a self-managed SQL Server database to an ApsaraDB RDS instance that runs SQL Server 2008 R2.