Exporting Data

Precautions

If you do not select Generate a file for each table when exporting data, the exported data file is in .zip format. Data files in this format cannot be directly imported. You need to decompress the file before importing it again.

If Generate a file for each table is selected during data export, the exported data file is in .sql or .csv format. In this case, the exported data file can be directly imported again.

Prerequisites

You have created a user keyspace on the DAS console.

Quickly Exporting Data

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner, and under Databases, click Data Admin Service.
4. In the navigation pane on the left, choose Development Tool.

   You can also click Go to Development Tool on the overview page.

5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
6. On the top menu bar, choose Import and Export > Export.
7. In the upper left corner of the page, click Quick Export and select the keyspace that you want to export data from.
   Figure 1 Quick export
   
   

   The quick export function exports data of an entire keyspace.

8. On the Quick Export page, select a storage path and click OK.
   Figure 2 Quick export
   

9. In the task list, view the export task you created.

   In the row that contains the export task, you can click Details in the Operation column to view execution details of the task and information about exported tables.

Exporting a Keyspace

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner, and under Databases, click Data Admin Service.
4. In the navigation pane on the left, choose Development Tool.

   You can also click Go to Development Tool on the overview page.

5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
6. On the top menu bar, choose Import and Export > Export.
7. In the upper left corner of the page, click Create Task and choose Export Keyspace.
   Figure 3 Creating a task for exporting a keyspace
   

8. In the displayed dialog box, configure basic information and advanced settings as required.
   Figure 4 Creating a task for exporting a keyspace
   
   • If you select Export all tables, data in an entire keyspace or in some tables will be exported.
   • DAS does not store any user data. The exported data files are stored in the OBS bucket that you have created.
   • Creating OBS buckets is free of charge, but saving files will incur certain costs.

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

Exporting CQL Results

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner, and under Databases, click Data Admin Service.
4. In the navigation pane on the left, choose Development Tool.

   You can also click Go to Development Tool on the overview page.

5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
6. On the top menu bar, choose Import and Export > Export.
7. In the upper left corner of the page, click Create Task and choose Export CQL Result.
   Figure 5 Creating a task for exporting a CQL result
   

8. In the displayed dialog box, configure basic information and advanced settings as required.
   Figure 6 Creating an export task
   
   • DAS does not store any user data. The exported data files are stored in the OBS bucket that you have created.
   • Creating OBS buckets is free of charge, but saving files will incur certain costs.

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

Download Data File