Help Center > > User Guide> MySQL DB Instance Management (Standard Edition)> Import and Export> Data Export

Data Export

Updated at: Sep 29, 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 a MySQL DB instance on the DAS console.

Procedure

  1. On the top menu bar, choose Import and Export > Export.
  2. On the displayed page, click Create Task and select 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. In the displayed dialog box, select a storage path and click OK.

    Figure 1 Quick Export

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

    Figure 2 Creating an export task
    • 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 the services in the system database 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.

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

    Figure 3 Task list

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