Export RDS data to a CSV file-ApsaraDB RDS(RDS)-阿里云帮助中心

This topic describes how to use DMS to export RDS data to an SQL script, CSV, or Excel file.

Check source data

In DMS, verify that Chinese characters display correctly in the query results, as shown in the following figure. 检查源数据

View the character set of a table

Run the following command to show a table's CREATE TABLE statement:

show create table <table_name>;

查看表的字符集

Create an export task

In DMS, choose Database Development > Data Export > Database Export.
Select Database Export.
Select the tables to export, configure the file type, character set, and other settings, and then click Submit.

FAQ

When I use an SQL script exported from DMS to restore data to a self-managed instance, why are only table structures restored, but not the data?

When you export data from DMS, you must select Export content for the Data & Structure option. Before you restore data to a self-managed instance, you must create the required database on the instance and then import the SQL script.