Export tasks

After you create a batch or single table export task in OceanBase Developer Center (ODC), you can view the task in the task list on the Export tab of the Task Center panel.

Task list

On the management page of the database connection, click Task Center in the top navigation bar to open the Task Center panel. Click Export to display the task list.

The following table describes the columns in the task list. You can filter and sort tasks by some of the columns.

Column	Description
Task ID	The ID of the export task.
Task Type	The task type specified when the task was created. The following task types are supported: import, export, data mocking, and database change.
Connection	The name of the database connection to which the task belongs. You can click the filter icon to filter the tasks by connection.
Database	The database to be changed. You can click the search icon to search for the database.
Creator	The user who created the export task. You can click the search icon to search for the creator.
Creation Time	The date and time when the task was generated.
Task Status	The current status of the task. ODC provides different management actions for tasks in different states.
Actions	The actions you can take. Valid values: View , Approve/Reject , Abort , and Download . * View: Click this button to go to the Task Details page to view the task information and task logs. * Approve/Reject: Click this button to approve or reject a running task. * Abort: Click this button to abort a running task. * Download: Click this button to download the exported file to your local device when the task is complete.

Create an export task

1. On the Task Center panel that appears, click + on the right side of Export, and a new export task panel will pop up.

   

2. In the Create Export Task panel, Specify the export content.

   

   ODC supports three export modes: Export Schema and Data, Export Data Only, and Export Schema Only. Export Schema Only exports the definition statements of the target object. You can select the export content from the Export Content drop-down list.

3. Select a database

   Select the database where the object to export resides. The name of the database connection to which the task belongs is also displayed.

4. Specify the export range

   You can select Partial Export or Full Export.

   • If you select Partial Export, you can select the objects you want to export in the Select Objects pane in the Export Objects section. You can use the search box to search for desired objects.

   • If you select Full Export, all objects in the database are exported.

5. Go to the Export Settings panel

   Click Next: Export Settings to specify the file export settings and the sys tenant account.

6. Go to the Data File Settings panel

   

   Note

   If you select Export Schema Only for Export Content, you do not need to configure the export data settings.

   a. Specify Data Format.

   ODC supports exporting data to files in the CSV format and SQL format. If you specify Export Schema Only for Export Content, you can only export data to files in the SQL format. For more information about formats, see Export and import formats.

   b. Specify File Encoding.

   ODC supports the following encoding standards: **ASCII**, **ISO-8859-1**, **GB2312**, **GBK**, **GB18030**, **Unicode (UTF-8)**, **Unicode (UTF-16)**, **Unicode (UTF-32)**, and **BIG5**. You can select the encoding standard from the **File Encoding** drop-down list.
   

   c. Specify Data Desensitization.

   By default, desensitization is disabled. You can select and manage the names of the desensitization strategies. In the Manage Desensitization Strategies section, you can add, edit, or delete strategies. For more information, see Manage data desensitization.

   d. Specify Maximum Size of a Single File.

   If you select **Export Schema Only** for **Export Content**, you do not need to set the maximum size of a single file.
   
   You can choose the upper limit of the exported single file.If the data file of a single table exceeds the upper limit, the file will be automatically split up. If you specify not to limit the file size, the file will not be split up.
   

   e. Specify Data File Settings.

   - **Use Global Snapshot**: If you select this option, ODC exports the data in the latest global snapshot of the specified table to ensure global data consistency.
   
   - **Batch Commit Quantity (SQL Format)**: You can click **Advanced** next to **Export Data Settings** to specify this field. If you select **SQL Format** for **Data Format**, you can specify the number of rows to be committed during the export. When this number is reached, a `COMMIT` command is executed.
   
   - Specify information for the CSV format. 
   

7. Specify schema file settings

   • If you select Export Schema Only for Export Content, you can choose whether to select Merge Exported Results into an SQL File. If you select this option, the DDL will be merged and exported as a SQL file.

   • Choose whether to select Add DROP TABLE Statement before CREATE TABLE Statement. If you select this option, a DROP statement is added before the corresponding CREATE statement of an object when the schema files of the object are exported.

8. Select an execution method

   Select Execute immediately or Timed execution.

9. Set up the sys tenant account

   a. Choose whether to select Use sys Tenant Account to Accelerate Export Task. If you select this option, specify Account and Password.

   b. After you specify the account and password, you can click the Test Connection button next to the password box to verify whether the account information is valid. By default, the account for the connection settings is automatically filled in. If the connection fails, we recommend that you change the password for this export.

   Notice

   • The account and password of the sys tenant are the account and password of a user in a cluster tenant. Do not enter @sys#cluster in the Account field. Example: account odc, password ******.
   • If the account of the sys tenant is not configured, indexes are not imported or exported.

10. Retain Current Configuration

    Check Retain Current Configuration to keep the current part of the data file and structure file configuration.

11. Generate an export task

    After you specify all preceding information, you can click Export in the lower-right corner of the panel to create an export task and export the backup file directly to a local directory.

View an export task

Task details

Click View in the Actions column of the row where the target task is located. The task details panel appears. Click Task Information in the upper-right corner of the panel to view the basic task information, information about the exported files, and information about the exported objects.

Task process

Click View in the Actions column of the row where the target task is located. The task details panel appears. Click Task Process in the upper-right corner of the panel to view information related to task initiation, approval, and execution status.

Task logs

Click View in the Actions column of the row where the target task is located. The task details panel appears. Click Task Logs in the upper-right corner of the panel to view the alert logs and all logs of the task.

In addition, the toolbar provides the following buttons: