Help Center > > User Guide> MySQL Database Management (Standard Edition)> Import and Export> Exporting Data

Exporting Data

Updated at: May 14, 2020 GMT+08:00

Scenarios

DAS supports pagination query to meet your requirements for querying large amounts of data. You can export all the data at a time when backing up or migrating data.

Prerequisites

You have logged in to the DAS console.

Procedure

  1. On the top menu bar, choose Import Export > Export.
  2. On the displayed page, click the Create Task drop-down list and choose Export Database or Export SQL Result as required. The following describes how to export the database. The procedure for exporting the SQL set is similar.

    Alternatively, you can click Quick Export to export the specified database information quickly.

  3. In the displayed dialog box, set required parameters in the Basic Information area and Advanced Settings area. Then, select the tables to be exported.

    • In a SQL result export task, the maximum size of the executed SQL statement is 5 MB.
    • Databases are classified into user databases and system databases. System database cannot be exported. If system databases are needed, you must create user databases, deploy the services on user databases, and then export the data.

  4. After the setting is complete, click OK.
  5. In the task list, view the task ID, type, status, and progress.
  6. Click Detail in the Operation column to view the task details.

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