Exporting Data
DAS allows you to export a large amount of data at a time to facilitate data query or to back up data for migration. This section describes how to export data.
DAS allows you to export an entire database, some data tables, or result sets of SQL statements.
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.
- If the Exporting a Database function is used to export over 100,000, PostgreSQL instance tables, an error message will be displayed indicating that the number of tables is too large and data cannot be exported. In this case, use the Exporting SQL Results function instead.
- This function is not available to PostgreSQL Enhanced Edition instances.
Exporting a Database
- Log in to the management console.
- Click in the upper left corner and select a region and project.
- Click in the upper left corner, and under Databases, click Data Admin Service.
- In the navigation pane on the left, choose Development Tool.
You can also click Go to Development Tool on the overview page.
- Locate the instance that you want to log in to and click Log In in the Operation column.
- On the top menu bar, choose Import and Export > Export.
- In the upper left corner of the page, click Create Task and choose Export Database.
Figure 1 Creating a task for exporting a database
- In the displayed dialog box, configure basic information and advanced settings as required.
Figure 2 Creating a task for exporting a database
Functions listed in Table 1 are automatically created by a PostgreSQL instance. When importing data on DAS, you need to manually delete the functions.
Table 1 Functions 1
public.create_plugin_pg_cron
2
public.drop_plugin_pg_cron
3
public.create_plugin_pg_repack
4
public.drop_plugin_pg_repack
5
public.create_plugin_dblink
6
public.drop_plugin_dblink
7
public.select_control_version
8
public.create_plugin_postgres_fdw
9
public.drop_plugin_postgres_fdw
10
public.create_plugin_pg_repack
11
public.drop_plugin_pg_repack
12
public.create_plugin_pg_stat_statements
13
public.drop_plugin_pg_stat_statements
14
public.create_plugin_pg_cron
15
public.drop_plugin_pg_cron
16
public.control_extension
17
public.control_tablespace
- If you select Export all tables, data in an entire database or in specific tables will be exported.
- Databases are classified into user databases and system databases. System database cannot be exported. If system database data is required, deploy system database services in a 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.
- DAS does not store any user data. The exported data files are stored in the OBS bucket that you have created. You can specify the storage path.
- Creating OBS buckets is free of charge, but saving files will incur certain costs.
- After settings are complete, click OK.
- In the task list, locate the created task and view the task ID, type, status, and progress.
- Click Details in the Operation column to view task details.
Figure 3 Task list
Exporting SQL Results
- Log in to the DAS console.
- Click in the upper left corner and select a region and project.
- Click in the upper left corner, and under Databases, click Data Admin Service.
- In the navigation pane on the left, choose Development Tool.
You can also click Go to Development Tool on the overview page.
- Locate the DB instance that you want to log in to and click Log In in the Operation column.
- On the top menu bar, choose Import and Export > Export.
- In the upper left corner of the page, click Create Task and choose Export SQL Result.
Figure 4 Creating a task for exporting SQL results
- In the displayed dialog box, configure basic information and advanced settings as required.
Figure 5 Creating a task for exporting SQL results
- In a SQL result export task, the executed SQL statements cannot exceed 5 MB.
- To export multiple SQL result sets at a time, enter SQL statements in the SQL text box. Enter each SQL statement on a separate line and add a semicolon (;) at the end. After the export task is complete, SQL files are generated. One SQL statement corresponds to one file.
- 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.
- After settings are complete, click OK.
- In the task list, locate the created task and view the task ID, type, status, and progress.
- Click Details in the Operation column to view task details.
Figure 6 Task list
Downloading Data Files
- Download on the DAS Console.
- Download on the OBS management console.
Quick Export (Not Promoted)
- Log in to the DAS console.
- Click in the upper left corner and select a region and project.
- Click in the upper left corner, and under Databases, click Data Admin Service.
- In the navigation pane on the left, choose Development Tool.
You can also click Go to Development Tool on the overview page.
- Locate the DB instance that you want to log in to and click Log In in the Operation column.
- On the top menu bar, choose Import and Export > Export.
- In the upper left corner of the page, click Quick Export and select the database that you want to export data from.
Figure 7 Quick export
A maximum of 200,000 rows can be quickly exported from a single table. To export more data, choose Create Task > Export Database.
- On the Quick Export page, select a storage path and click OK.
Figure 8 Quick export
- In the task list, view the export task you created.
Figure 9 Task list
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.Figure 10 Task details
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot