Exporting Data
To export data from a specified instance database and table to a local destination, you can submit a data export ticket request process.
Operating Procedures
The data export operation process is as follows:
1. Submit a ticket request: Select the instance and database, the data table to export, the file type, and the export content.
2. Approval: After submitting the ticket, proceed with manual approval.
3. Execution: After the ticket is approved, the data export is automatically executed.
4. Completion: After execution is completed, view the results and download the exported file.
Prerequisites
If operating users are regular DMC users, they need to apply for or be granted database change permissions. For related operations, see Apply for Instance Permissions (Regular User), Batch User Authorization (Administrator), or View and Reclaim Instance Permissions.
Use Limits
Only the MySQL data type supports data export.
Directions
1. Log in to the DMC console.
2. In the top menu bar, select Data Management > Export Data.
3. Configure the parameters for the database instance, database and table, and export file type. Click Submit upon completion.
Parameter | Description |
Instance | Select the database instance to be exported. |
Database | Select the database to be exported. |
Export Data Table | Select the data table to be exported. If no specific table is selected, the entire database will be exported by default. |
File Type | File types include SQL and CSV. SQL: Export Content: Includes data, structure, or both data and structure. Whether to lock the table: Select whether to lock the table. Export Object: Include stored procedures and functions, triggers, views, and events. Data Options: Include marking dumped binary fields with hexadecimal notation and disabling foreign key constraints. Other Options: Include generating DROP statements before CREATE statements and generating TRUNCATE TABLE statements before INSERT statements. CSV: Select whether the first row of the exported table data is column names or data. |
File Encoding | Select the file encoding format, including UTF-8, GBK, GB2312, or latin1. |
Reason | Enter the reason for the data export request to expedite the approval process. |
4. On the Ticket Management page, check the ticket status.
If the ticket status is Reviewing, wait for the approval to be completed. Once the ticket is approved, the system will automatically execute the ticket. When the status displays Execution successful, proceed to the next step.
If the ticket status is Rejected, click View Details in the operation column to check the rejection reason.
5. In the operation column corresponding to the ticket, click View Details. In the pop-up dialog box, click Click to get the download URL, and click the file name to download the exported file to your local system.
Help and Support
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback