Updated on 2023-12-13 GMT+08:00

Exporting Data

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.

DAS allows you to export an entire database, some data tables, or result sets of SQL statements.

Precautions

If you do not select Generate a file for each table when exporting data, the exported data file is in .zip format. Data files in this format cannot be directly imported. You need to decompress the file before importing it again.

If Generate a file for each table is selected during data export, the exported data file is in .sql or .csv format. In this case, the exported data file can be directly imported again.

Prerequisites

You have created a user database on the DAS console. For details, see Creating a Database.

Quickly Exporting Data

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
  6. On the top menu bar, choose Import and Export > Export.
  7. In the upper left corner of the page, click Quick Export and select the database that you want to export data from.

    Figure 1 Quick export

    The quick export function exports data of an entire database.

  8. On the Quick Export page, select a storage path and click OK.

    Figure 2 Quick export

  9. In the task list, view the export task you created.

    Figure 3 Task list
    In the row that contains the export task, you can click Details in the Operation column to view execution details of the task and information about exported tables.
    Figure 4 Task details

Exporting a Database

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
  6. On the top menu bar, choose Import and Export > Export.
  7. In the upper left corner of the page, click Create Task and choose Export Database.

    Figure 5 Creating a task for exporting a database

  8. In the displayed dialog box, configure basic information and advanced settings as required.

    Figure 6 Creating a task for exporting a database
    • If you select Export all tables, data in an entire database or in specific tables will be exported.
    • 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 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.
    • DAS does not store any user data. The exported data files are stored in the OBS bucket that you have created.
    • Creating OBS buckets is free of charge, but saving files will incur certain costs.

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

    Figure 7 Task list

Exporting SQL Results

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
  6. On the top menu bar, choose Import and Export > Export.
  7. In the upper left corner of the page, click Create Task and choose Export SQL Result.

    Figure 8 Creating a task for exporting SQL results

  8. In the displayed dialog box, configure basic information and advanced settings as required.

    Figure 9 Creating a task for exporting SQL results
    • In a SQL result export task, the executed SQL statements cannot exceed 5 MB.
    • To export multiple SQL result sets at a time, enter SQL statements in the SQL text box. Enter each SQL statement on a seperate line and add a semicolon (;) at the end. After the export task is complete, SQL files are generated. One SQL statement corresponds to one file.
    • DAS does not store any user data. The exported data files are stored in the OBS bucket that you have created.
    • Creating OBS buckets is free of charge, but saving files will incur certain costs.

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

    Figure 10 Task list

Downloading Data Files

Data exported using the data export function is stored in the OBS bucket you created. You can download exported data files in any of the following ways:
  • Download on the DAS Console.
  • Download on the OBS management console.