All Products
Search
Document Center

Import data

Last Updated: Jun 08, 2019

This topic describes how to import data to DMS.

Prerequisites

You have access permissions to DMS and you have logged on to the DMS console.

Background

This example uses MySQL databases.

Procedure

  1. Log on to the DMS console. The initial page is shown as below.

  2. Select a database, and click Log on to Database.

  3. In the top navigation bar, choose Data Processing>Import.

    Data import entrance

  4. You can view the data import toolbar and the history on the data import window.

    Notes

    If you have imported data to DMS, the History table displays the data operation history.

  5. Click Create Task to open the Import Task window. Specify the file information based on your needs.

    Notes

    • Only SQL and CSV files are supported.

    • If the data file to be imported uses a character set, you can manually specify the character set. By default, DMS detects the character sets of files.

    • If an error occurs while executing a SQL statement, DMS will terminate the import task. You can select Ignore Errors, but the errors may affect the subsequent operations.

    • You can enter a task description to briefly specify the reason and the imported content for later review.

  6. Click Start to run the import task. If the imported data has an error, DMS will terminate the import process and return an error message. If an error occurs, you can modify the data file and import the data again.

  7. If the imported data and SQL statements are correct, DMS displays the import progress, the imported data volume, and the consumed time.

  8. After data is imported, you can view the import task in History. Click Task ID to view the execution details of the task.