Migrating Data to GaussDB Using the Export and Import Functions of DAS

Scenarios

Data Admin Service (DAS) is a one-stop management platform that allows you to manage Huawei Cloud databases on a web console. It offers database development, O&M, and intelligent diagnosis, making it easy for you to use and maintain databases.

To back up or migrate data, you can use DAS to export data from the source database first and then import the data from your local PC or OBS bucket to the destination database.

For more information, see Data Import and Export.

Constraints

• The file to be imported should be no larger than 1 GB.
• Only data files in the CSV or SQL format can be imported.
• Binary fields such as BINARY, VARBINARY, TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB are not supported.
• Data cannot be exported or imported using cross-region OBS buckets.

Exporting Data

1. Log in to the management console.
2. Click in the upper left corner and select the desired region and project.
3. Click in the upper left corner of the page and choose Databases > GaussDB.
4. On the Instances page, locate the DB instance you want to log in to and click Log In in the Operation column.
5. On the displayed login page, enter the username and password and click Log In.
6. On the top menu bar, choose Import and Export > Export.
7. On the displayed page, click Create Task and choose Export Database or Export SQL Result as required. The following takes database export as an example.

   Alternatively, click Quick Export and select the target database. On the displayed page, select a storage path and click OK.

   Figure 1 Quick export
   

8. On the displayed page, set parameters as required in areas Basic Information and Advanced Settings. Then, select the tables to be exported on the right.
   Figure 2 Creating an export task
   
   

   • In a SQL result export task, the executed SQL statements cannot exceed 5 MB.

     

   • Databases are classified as user databases or system databases. System databases cannot be exported. If system database data is required, deploy system database services in a created user database, so that you can export the system database data from the user database.
   • DAS connects to your standby database to export data. This prevents the primary database from being affected by data export. However, if the standby database has a high replication delay, the exported data may not be the latest.

9. After settings are complete, click OK.
10. In the task list, view the task ID, type, status, and progress.
11. Click Details in the Operation column to view task details.
    Figure 3 Task list
    

Importing Data

1. On the top menu bar, choose Import and Export > Import.
2. Import a file from your local PC or an OBS bucket.
   Figure 4 Creating an import task
   
   • From your local PC

     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, set other parameters as required.

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

     

     • To keep your 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 uploaded will be automatically deleted from the OBS bucket after being imported to the destination database.
   • 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, set 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.