All Products
Search

This Product

    ApsaraDB RDS:Use DMS to export data to a CSV file or an SQL or Excel file

    Document Center

    ApsaraDB RDS:Use DMS to export data to a CSV file or an SQL or Excel file

    Last Updated:Mar 12, 2025

    This topic describes how to use Data Management (DMS) to export data to a CSV file.

    Check source data

    In the DMS console, check whether data is displayed.检查源数据

    View the character set of a table

    Execute the following statement to create a table: 

    show create table <Table name>;

    查看表的字符集

    Create an export task

    1. In the DMS console, choose Database Development > Data Export > Database Export.

    2. Click Database Export.

    3. Select the table that you want to export, configure parameters such as File Format and Exported Structure Type, and then click Submit. 设置导出任务

    FAQ

    When I use the SQL file that is exported from DMS to restore data to a self-managed instance, only the table names are restored. Why?

    When you use DMS to export data, you must set the Export content parameter to Data & Structure. Before you use the exported file to restore data to a self-managed instance, you must create the required databases on the instance and export SQL scripts to the databases.