Help Center > > User Guide> GaussDB(for MySQL) DB Instance Management (Standard Edition)> Import and Export> Data Import

Data Import

Updated at: Sep 29, 2020 GMT+08:00

Scenarios

This topic describes how to import data into a table for backup or data migration. The table structure to be imported must be the same as that of the target table. If you import a CSV or SQL file, the data type of the target table must be the same. The imported file should be no larger than 10 GB.

Prerequisites

You have logged in to a GaussDB(for MySQL) DB instance on the DAS console.

Procedure

  1. On the top menu bar, choose Import and Export > Import.
  2. Import a file from your local PC or an OBS bucket.

    • From your local PC

    On the displayed page, click Create Task. In the displayed dialog box, set File Source to Upload file, specify the attachment storage, and upload a file from your local PC. Then, configure other parameters as required.

    For security purposes, imported files are stored in OBS buckets.

    • To keep data secure, provide your own OBS bucket to store the attachments you upload. In this way, DAS automatically connects to your OBS bucket for in-memory reading.
    • If you select Delete the uploaded file upon an import success, the file you upload will be automatically deleted from the OBS bucket after being imported to the destination database.
    • From an OBS bucket

      On the displayed page, click Create Task. In the displayed dialog box, set File Source to Choose from OBS, and configure other parameters as required.

    The file uploaded from an OBS bucket will not be deleted upon an import success.

  3. After setting the import parameters, click Create. Confirm the information again before you click OK because original data may be overwritten after data import.
  4. View the import progress in the task list or check task details.

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