Help Center > > User Guide> MySQL Database Management> Data Editing> Batch Exporting Data

Batch Exporting Data

Updated at: Mar 20, 2020 GMT+08:00

Scenarios

Export files in batches on the DAS console to improve the efficiency in exporting a large amount of data.

Prerequisites

You have logged in to the DAS console.

Procedure

  1. On the top menu bar, choose Import Export > Batch Export.
  2. Click New Task. There are three types of batch export tasks: Export Database, Export SQL Result, and Quick Export Database.

    • Export Database

      You can select a specified database, set export information, and export table data in batches.

    • Export SQL Result

      You can select a specified database and execute the SQL statement to obtain the result set.

    • Quick Export Database

      Select the name of the database to be exported, select or create an OBS bucket for storing data files, and export data in batches.

      1. The default file type is CSV.
      2. If you select Include Attributes for Options, the first row of the file contains the attribute name.

  3. Create an export task using the exporting the database as an example.

    Click Export Database. On the displayed page, set the required parameters.
    Table 1 MySQL database parameter configuration

    Basic Information

    Database

    Databases cannot be exported across instances. Only databases in this instance can be exported.

    File Type

    Only CSV and SQL files are supported.

    OBS bucket

    To ensure information security, the exported data is stored in the OBS bucket. You can create an OBS bucket or select an existing OBS bucket to store the exported database information.

    Output Format

    If the output format is set to SQL, you can export the structure and data at the same time, or export either data or structure.

    Options

    • Include Attributes: indicates that the exported data contains the parameter information of the table.
    • Generate file by table: indicates that the exported data is compressed, and each table is exported to a file. If the output format is set to SQL, only single table files can be generated.

    Comment

    Enter remarks.

  4. Click Export. You can select all tables in the database or specified tables. All exported data is stored in the OBS bucket.

    The exported files can be retained for a maximum of 24 hours.

    You can choose to delete them.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel