Data Importing
When you need to import data from local files or files stored on COS into a specified database and table of an instance, you can submit a data import ticket request.
Operating Procedures
The data import operation process is as follows:
1. Submit a ticket request: Select the instance and database, execution method, and file type, and upload the file.
2. Approval: After submitting the ticket, proceed with manual approval.
3. Execution: After approval, proceed with either automatic execution or manual execution import.
4. Completion: After the execution is completed, view the execution results.
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.
Limits
Only the MySQL data type supports data import.
Directions
1. Log in to the DMC console.
2. In the top menu bar, select Data Management > Import Data.
3. Configure the parameters for the database instance, databases and tables, and import methods, and click Submit upon completion.
Parameter | Description |
Instance | Select the instance for the data to be imported. |
Database | Select the database to be imported. |
Execution Mode | Select the approval execution method, including automatically execute after approval and manually execute after approval. |
File Type | File types include SQL and CSV. SQL: Ensure the SQL statements are correct. Separate multiple SQL statements with a semicolon (;). CSV: Data should use a comma (,) as the delimiter. After selecting the CSV file type, configure the following parameters. Import to Data Table: Select the table where the data will be imported. First Row: Select whether the first row of the data to be imported represents column names or data. Import Method: Select INSERT or REPLACE. |
Upload File | Upload a file: Click Select File to upload a local file. Only files smaller than 10 GB are allowed. Use a COS object: Enter the COS source file address. Only files smaller than 10 GB are allowed, and the file should have public read or private read with a signature enabled. |
File encoding | Select the file encoding format, including UTF-8, GBK, GB2312, or latin1. |
Reason | Enter the reason for the data import 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. After approval, proceed to the next step. For ticket approval operations, see Approve Ticket.
If the ticket status is Rejected, click View Details in the operation column to check the rejection reason.
5. (Optional) On the Ticket Management page, click Execute in the Operation column corresponding to the pending ticket. Then click Execute Now in the Data Import Ticket dialog box. When the ticket status displays Execution Successful, it indicates that the data has been successfully imported into the specified database.
If the Execution Method selected during ticket submission is Auto-execute after approval, the ticket status displaying Execution Successful indicates that the data has been successfully imported into the specified database.
6. On the Ticket Management page, click View Details in the Operation column corresponding to the executed ticket.
View ticket details and execution results (either execution failure or execution successful).
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