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 the .csv file, the data type of the target table must be the same. The maximum size of a file that can be imported is 10 GB.
You have logged in to the DAS console.
- On the top menu bar, choose Import Export > Import.
- Import the data. DAS allows you to import a file from a local path or an OBS bucket.
- Import the file from a local path.
In the upper left corner, click Create Task. On the displayed page, select an import type, select Upload File for File Source, set the attachment storage, and upload the file. Then, select the destination database, charset, and option, and enter the remarks.
Files in DAS are stored in OBS buckets for security.
- To protect data privacy, you need to provide your own OBS storage to receive the files to be uploaded. Then, DAS automatically connects to OBS and reads data in memory. During that process, your data will not be stored on any storage medium of DAS.
- If you select Delete the uploaded file when import completed, the file you uploaded will be automatically deleted from the OBS bucket after being imported to the destination database.
- Import the file from an OBS bucket.
In the upper left corner, click Create Task. On the displayed page, select an import type, select Choose From OBS for File Source, and select a file from the bucket. Then, select the destination database, charset, and option, and enter the remarks.
When the file is imported from an OBS bucket, the file will not be deleted after the import succeeds.
- After setting the import information, click Create. The original data may be overwritten after data import. Therefore, confirm the information before you click OK.
- View the task progress in the task list or check task details.