Import database files by using DMS

Demonstration video

This video demonstrates how to import an SQL file by using DMS. The UI shown is for reference only.

Procedure

1. Log on to the MySQL database on your Linux-based web hosting instance.

   For more information, see Log on to a database by using the web-based DMS.

2. On the SQLConsole page, under the Table tab, right-click your target table, for example, test, and click Import.

3. In the Data Import dialog box, configure the parameters and then click Submit Request.

   The following table describes the parameters.

   Parameter	Description	Example
   Database	The target database for the data import. The system selects this automatically.	bdm721**_db@[bdm721**.my3w.com:3306]
   File encoding	Select the encoding of the import file: UTF-8 GBK ISO-8859-1 Auto-detect	Auto-detect
   Import mode	Select an import mode. Two modes are supported: Express Mode: Reads the file during the execution phase and directly runs the SQL statements in the target database. This mode is faster but less secure than Safe Mode. Safe Mode: Parses the file during the pre-check phase and caches the SQL or CSV data. During the execution phase, the data is read from the cache and executed in the target database. This mode is more secure but slower than Express Mode.	Express Mode
   File type	The type of file to import. The following types are supported: SQL script: In Secure Collaboration mode, only the INSERT and REPLACE commands are allowed by default. CSV file: The delimiter in the file must be a comma (,). Excel file: The Excel file can contain a header row with attribute names, or it can contain only data.	SQL Script
   Attachment	The file to import from your on-premises host. Click Upload File to select it. Note SQL, CSV, TXT, XLSX, and ZIP files are supported. The attachment cannot exceed 5 GB.	qdm16****_sql.zip

4. On the Data Import Ticket List page, confirm that the ticket has passed the pre-check and approval stages.

5. In the Execute section, click Execute Change.

6. In the Task Settings dialog box, select an Execution Policy and click Confirm Execution.

   Important

   We recommend performing this change during off-peak hours to avoid business interruptions.

   • Execute immediately: The default policy. The system executes the ticket immediately.

   • Scheduled execution: Select a start time for the task. The system automatically executes the task at the specified time.