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

Note
The task list displays the tasks in the last 48 hours. ODC allows you to run up to three export tasks in parallel, while subsequent tasks wait in the queue.

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. Log on to ODC and go to the management page of the target connection. In the top navigation bar, click Task Center . On the Task Center panel that appears, choose All Tasks > Export > Create Export Task and create an export task.

2. In the Create Export Task panel, specify information as described in the following table.

   Field	Description
   Connection	The name of the database connection to which the task belongs.
   Database	The database to be changed.
   Export Content	When you select ZIP for Export File Format, you must specify this parameter. ODC supports three export modes: Export Data Only , Export Schema Only , and Export Schema and Data .
   Data Format	Specify Data Format . ODC currently supports exporting data to files in CSV format and SQL format. If you specify Export Schema Only for Export Content , you can only export data to files in SQL format. For more information about formats, see Export and import formats.
   Encoding Standard	Specify Encoding Standard . ODC supports the following character sets: ASCII , ISO-8859-1 , GB2312 , GBK , GB18030 , Unicode (UTF-8) , Unicode (UTF-16) , Unicode (UTF-32) , and BIG5 . You can select one from the Encoding Standard drop-down list.
   Export Objects	Specify Export Objects . The Export Objects tab displays the Object Name and Object Type of the current table.
   Export Data Settings	If you specify Export Schema Only for Export Content , you do not need to complete the export data settings. You need to specify the following fields: * 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. * Skipped Data Types : You can click Advanced Settings next to Export Data Settings to specify this field. Here, you can specify the data types that you want to skip when you export the data. The data types that can be skipped are different in MySQL and Oracle modes. You can select multiple data types. * Specify information for the CSV format. If you specify the CSV format for Data Format and Export Data Only or Export Schema and Data for Export Content , you can click Advanced Settings next to Export Data Settings to specify the following fields: * Include Column Header : This option is selected by default to determine whether to include column headers when data is exported in CSV format. * Convert Empty String to Null Value : This option is selected by default to determine whether to convert empty strings in the table to NULL values (\N) when data is exported in CSV format. * Field Delimiter : This option specifies the delimiter between fields. The following signs are supported: commas ( , ), semicolons ( ; ), and colons ( : ). You can also use a character as the delimiter. * Text Identifier : This option specifies the identifier for the text content. Single quotation marks ( ' ) and double quotation marks ( " ) are supported. * Line Break Sign : This option specifies the sign for the line break. The following characters are supported: \n , \r , and \r\n .
   Sys Tenant Account Settings	Configure Sys Tenant Account Settings . Select Use sys Account to Accelerate Export Task or not. If you select this option, you need to enter the account and password of the SYS tenant in the Account and Password fields. Then, you can use permissions of this account to export data, which accelerates the export task. You can access the views under the SYS tenant to obtain the optimal data routing strategy. Notice - The account and password of a user in the SYS tenant are required. Do not enter @sys#cluster in the Account field. The following figure shows an example. - To export objects other than tables and views, you must specify the SYS tenant account. - Otherwise, annotations and indexes are not imported or exported.

3. Click Export . The export task is created.

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: