Help Center > > User Guide> MySQL Database Management> Table Management> Importing Table Data

Importing Table Data

Updated at: Mar 20, 2020 GMT+08:00

Scenarios

This section describes how to import data into a table for backup or data migration. The table structure in the file must be the same as that of the target table, and the file size cannot exceed 15 MB.

Prerequisites

You have logged in to the DAS console.

Procedure

  1. In the navigation tree on the left, right-click the target table and choose Import Table Data from the shortcut menu.
  2. Select the CSV or SQL file format as required, specify the required parameters, and click Import.

    • If you select CSV, specify Option, Data Position, and Write Mode.
    • If you select SQL, set the parameters as required.
      • If you do not select Option, the import action stops immediately when an error occurs.
      • If you select Option, the system skips the error and continues importing the file

  3. In the displayed dialog box, view the imported information. Then, click Close.

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