All Products
Search
Document Center

Data Management:Export databases

Last Updated:Jan 22, 2024

Data Management (DMS) provides the database export feature. You can use this feature to back up databases and export databases or tables for data analysis. You can submit a ticket to export databases.

Prerequisites

The database is of one of the following types:

  • MySQL: self-managed MySQL, ApsaraDB RDS for MySQL, PolarDB for MySQL, AnalyticDB for MySQL, and ApsaraDB for OceanBase in MySQL mode

  • SQL Server: self-managed SQL Server and ApsaraDB RDS for SQL Server

  • PostgreSQL: self-managed PostgreSQL, ApsaraDB RDS for PostgreSQL, PolarDB for PostgreSQL, and AnalyticDB for PostgreSQL

  • Oracle: PolarDB for PostgreSQL (Compatible with Oracle)

  • ApsaraDB for MariaDB and MariaDB databases from other sources

Usage notes

  • DMS allows you to export up to one million data rows for free per day for instances managed in Flexible Management mode, up to 20 million data rows for free per day for instances managed in Stable Change mode, and an unlimited number of data rows for instances managed in Security Collaboration mode. If you need to export a large number of data rows every day, you can change the control mode of the instances to Security Collaboration. For more information, see Change the control mode of an instance.

  • After you submit a data export ticket for approval, you can close the ticket regardless of whether the ticket is approved or rejected. This reduces data exposure. To close a ticket, go to the Ticket Details page of the ticket and click Close Ticket in the upper-right corner of the page.

Procedure

  1. Log on to the DMS console V5.0.
  2. In the top navigation bar, choose Database Development > Data Export > Database Export.

    Note
    • If you use the DMS console in simple mode, move the pointer over the 2023-01-28_15-57-17.png icon in the upper-left corner and choose All functions > Database Development > Data Export > Database Export.

    • You can also choose SQL Console > SQL Console in the top navigation bar. In the left-side pane of the page that appears, right-click the table that you want to export and select Export.

  3. On the Data Export Tickets page, configure the parameters that are described in the following table.

    Parameter

    Description

    Database Name

    The database that you want to export.

    Note

    You must have the export permissions on this database. For more information, see View owned permissions.

    Exported table

    Specifies whether to export specific tables or all tables in the database. Valid values: Partial Tables and All Tables.

    Note

    If you set this parameter to Partial Tables, you must select one or more tables in the Tables & Filters section and configure the filter condition.

    Reason Category

    The reason for this export. This helps you find the ticket in subsequent operations.

    Business Background

    The purpose or objective of this export. This reduces unnecessary communication.

    Stakeholder

    The stakeholders involved in this export. All specified stakeholders can view the ticket details and take part in the approval process. Irrelevant users other than DMS administrators and database administrators (DBAs) are not allowed to view the ticket details.

    Export content

    The type of data that you want to export. Valid values: Data, Structure, and Data & Structure.

    File Format

    The format in which the database is exported. Valid values:

    • SQL

    • CSV

    • EXCEL

    Exported Structure Type

    The type of schema that you want to export. Valid values:

    • Procedure

    • Function

    • Trigger

    • View

    • Event

    Note

    The valid values vary based on the type of database that you want to export.

    More Options

    Other objects you want to export. Click Big data type export options or SQL script other options and select the required options.

    Attachments

    The images or files that are uploaded to add more information about this export.

  4. Click Submit.

    Note
    • On the Ticket Details page, you can view the approval progress in the Approval section.

    • Approval rules are configured by DMS administrators and DBAs. For more information about how to customize an approval process, see Customize approval processes.

  5. After the ticket is approved, click Download Exported File in the Download step.

    Important

    You must download the exported file within 24 hours after the ticket is executed. Otherwise, the export link becomes invalid and you need to submit a ticket again.

Other supported operations

  • After you export data, you can perform the following operations:

    • You can import the exported data to another database. For more information, see Import data.

    • If you need to delete a database after you export the data in the database, perform the following operations: In the left-side navigation pane on the Home tab, right-click the database instance that you want to manage and select Database management. On the page that appears, find the database that you want to delete, click Delete in the Actions column, and then click OK. For more information about how to delete a database, see Manage databases.

  • You can also call the following API operations to create and execute a database export ticket: