Updated on 2023-04-17 GMT+08:00

Data Export

Prerequisites

You have created a user database on the MySQL database management page. For details, see Creating a Database.

Scenarios

DAS allows you to export a large amount of data at a time to facilitate data query or to back up data for migration. This section describes how to export data.

Procedure

  1. On the login page, enter your account and password to log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Under Database, click Data Admin Service.
  4. Locate the target database and click Log In in the Operation column. The homepage of the MySQL database management is displayed.
  5. On the top menu bar, choose Import and Export > Export.
  6. On the displayed page, click Create Task and choose Export Database or Export SQL Result as required. The following takes database export as an example.

    Alternatively, click Quick Export and select the target database. On the displayed page, select a storage path and click OK.

  7. On the displayed page, set parameters as required in areas Basic Information and Advanced Settings. Then, select the tables to be exported on the right.

    • In a SQL result export task, the executed SQL statements cannot exceed 5 MB.

    • Databases are classified into user databases and system databases. System database cannot be exported. If system database data is required, deploy system database services in a created user database, so that you can export the system database data from the user database.
    • DAS connects to your standby database to export data. This prevents the primary database from being affected by data export. However, if the standby database has a high replication delay, the exported data may not be the latest.

  8. After settings are complete, click OK.
  9. In the task list, view the task ID, type, status, and progress.
  10. Click Details in the Operation column to view task details.