Use DMS to import a logical backup file into an ApsaraDB RDS instance
Use the data import feature of Data Management (DMS) to import a logical backup file into an ApsaraDB RDS instance for backup restoration or data migration.
When to use this method
Use this method when you have an RDS logical backup file in SQL or CSV format and want to import it through a graphical interface.
Prerequisites
Before you begin, ensure that you have:
An ApsaraDB RDS for MySQL instance as the import target
A backup file in SQL or CSV format
Enough permissions to perform data import operations in DMS
Limitations
DMS data import supports SQL and CSV files only. Download the backup file in one of these formats before proceeding.
To get the most recent backup, perform a manual backup first, then download the generated file. For details, see Perform a manual backup.
Import a backup file using DMS
Step 1: Download the backup file
Download the backup file of your RDS instance. For detailed steps, see Download backup files.
Step 2: Import the backup file
Use the data import feature of DMS to import the SQL or CSV file into the target RDS instance. For detailed steps, see Import data.
What's next
Download backup files for ApsaraDB RDS for PostgreSQL
Download backup files for ApsaraDB RDS for SQL Server