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.
• 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

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 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 Database.
   Figure 1 Creating a task for exporting a database
   

8. 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.

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.
    Figure 3 Task list
    

Exporting SQL Results

1. Log in to the DAS 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 SQL Result.
   Figure 4 Creating a task for exporting SQL results
   

8. 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.

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.
    Figure 6 Task list
    

Downloading Data Files

Quick Export (Not Promoted)

1. Log in to the DAS 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 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.

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

9. 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