You need to enable JavaScript to run this app.
文档中心
云数据库 TiDB 版

云数据库 TiDB 版

复制全文
下载 pdf
导出任务管理
CreateExportTask - 创建导出任务
复制全文
下载 pdf
CreateExportTask - 创建导出任务
调用 CreateExportTask 接口创建导出任务。​
调试​
API Explorer
您可以通过 API Explorer 在线发起调用,无需关注签名生成过程,快速获取调用结果。
​
请求参数​
下方仅列出该接口特有的请求参数和部分公共参数。更多信息请见公共参数。​
Action string 必选 示例值:CreateExportTask​
要执行的操作,取值:CreateExportTask。​
​
Version string 必选 示例值:2026-06-30​
API的版本,取值:2026-06-30。​
​
ExportOptions object 可选 示例值:{ "FileType": "PARQUET", "Filter": { "Table": { "Patterns": [ "*.*" ] } }, "ParquetFormat": { "Compression": "SNAPPY" } }​
导出选项。​
FileType string 可选 示例值:PARQUET​
数据格式。取值如下:​
  • SQL:SQL 格式。​
  • CSV:CSV 格式。​
  • Parquet:Parquet 格式。​
​
Compression string 可选 示例值:ZSTD​
压缩算法。取值如下:​
  • ZSTD:ZSTD 压缩格式。​
  • Gzip:Gzip 压缩格式。​
  • Snappy:Snappy 压缩格式。​
  • NONE:无压缩。​
​
Filter object 可选 示例值:{ "Table": { "Patterns": [ "test.*" ] } }​
过滤条件。​
Sql string 可选​
SQL 过滤条件。​
​
Table object 可选 示例值:{ "Patterns": [ "*.*" ] }​
表过滤规则。​
Patterns string[] 可选 示例值:*.*​
表匹配规则。例如:​
  • *.*:匹配该数据源下所有库的全部表。​
  • test.*:匹配 test 库下面的全部数据表。​
  • test.name:精准匹配 test 库下面的 name 表。​
​
Where string 可选​
WHERE 条件。​
​
​
​
CsvFormat object 可选​
CSV 格式配置。​
Separator string 可选 示例值:,​
列分隔符。​
​
Delimiter string 可选 示例值:\"​
定界符。​
​
NullValue string 可选 示例值:\\N​
NULL 的字符串表示。​
​
SkipHeader boolean 可选 示例值:true​
是否跳过表头。取值如下:​
  • true:跳过表头。​
  • false:不跳过表头。​
​
​
ParquetFormat object 可选​
Parquet 格式配置。​
Compression string 可选 示例值:ZSTD​
压缩算法。取值如下:​
  • ZSTD:ZSTD 压缩格式。​
  • Gzip:Gzip 压缩格式。​
  • Snappy:Snappy 压缩格式。​
  • NONE:无压缩。​
​
​
​
Target object 必选 示例值:{ "Type": "TOS", "Tos": { "Uri": "tos://test/", "AuthType": "ACCESS_KEY", "AccessKey": { "Id": "AKLTNGRlYWNiMzJhMTYyNGEzMmIxNzg0YjQ1OGFi********", "Secret": "TWpVME9HUTBOR0UzT0Rka05HTTFOVGxoWTJaaU1XWTVOem**************" } }​
目标存储配置。​
Type string 可选 示例值:TOS​
目标类型。​
​
Tos object 可选 示例值:{ "AccessKey": { "Id": "AKLTNGRlYWNiMzJhMTYyNGEzMmIxNzg0Y*****************" }, "AuthType": "ACCESS_KEY", "Uri": "tos://test/" }​
TOS 目标配置。​
Uri string 可选 示例值:tos://test/​
TOS URI。​
​
AuthType string 可选 示例值:ACCESS_KEY​
固定为 ACCESS_KEY。​
​
AccessKey object 可选 示例值: "Id": "AKLTNGRlYWNiMzJhMTYyNGEzMmIxNzg0YjQ1O**********" }​
访问凭证。​
说明​
如何获取 AccessKey ID 及 AccessKey Secret,请参见 Access Key(密钥)管理。​
Id string 可选 示例值:AKLTNGRlYWNiMzJhMTYyNGEzMmIxNz*******************​
AccessKey ID。​
​
Secret string 可选 示例值:*********​
AccessKey Secret。​
​
​
​
​
ExportTaskName string 可选 示例值:exportname1​
导出任务名称。​
​
ProjectName string 可选 示例值:default​
项目名称。​
​
InstanceId string 必选 示例值:tidb-cd4a36******​
实例 ID。​
​
​
​
返回参数​
下方仅列出本接口特有的返回参数。更多信息请参见返回结构。​
Export_ object 示例值:{ "InstanceId": "tidb-cd4a36******", "CreateTime": "2026-10-26T03:47:54.045Z", "ExportId": "exp-3lqt4545jzfyna5dwcf6******", "ExportOptions": { "Compression": "ZSTD", "FileType": "SQL", "Filter": { "Table": { "Patterns": [ "test.*" ] } } }, "ExportTaskName": "export1", "SnapshotTime": "2026-10-26T03:47:53.268Z", "State": "RUNNING", "Target": { "Tos": { "AccessKey": { "Id": "AKLTN*********IxNzg0YjQ1OGFiMm***" }, "AuthType": "ACCESS_KEY", "Uri": "tos://test/" }, "Type": "TOS" } }​
创建成功的导出任务信息。​
ExportId string 示例值:exp-q3knvcfwo5csdie7suod******​
导出任务 ID。​
​
State string 示例值:RUNNING​
任务状态。​
​
ExportOptions object 示例值:{ "Compression": "NONE", "FileType": "PARQUET", "Filter": { "Table": { "Patterns": [ "*.*" ] } }, "ParquetFormat": { "Compression": "SNAPPY" } }​
导出选项。​
FileType string 示例值:PARQUET​
数据格式。取值如下:​
  • SQL:SQL 格式。​
  • CSV:CSV 格式。​
  • Parquet:Parquet 格式。​
​
Compression string 示例值:ZSTD​
压缩算法。取值如下:​
  • ZSTD:ZSTD 压缩格式。​
  • Gzip:Gzip 压缩格式。​
  • Snappy:Snappy 压缩格式。​
  • NONE:无压缩。​
​
Filter object 示例值:{ "Table": { "Patterns": [ "test.*" ] } }​
过滤条件。​
Sql string​
SQL 过滤条件。​
​
Table object 示例值:{ "Patterns": [ "*.*" ] }​
表过滤规则。​
Patterns string[] 示例值:*.*​
表匹配规则。例如:​
  • *.*:匹配该数据源下所有库的全部表。​
  • test.*:匹配 test 库下面的全部数据表。​
  • test.name:精准匹配 test 库下面的 name 表。​
​
Where string​
WHERE 条件。​
​
​
​
CsvFormat object​
CSV 格式配置。​
Separator string 示例值:,​
列分隔符。​
​
Delimiter string 示例值:\"​
定界符。​
​
NullValue string 示例值:\\N​
NULL 的字符串表示。​
​
SkipHeader boolean 示例值:true​
是否跳过表头。取值如下:​
  • true:跳过表头。​
  • false:不跳过表头。​
​
​
ParquetFormat object​
Parquet 格式配置。​
Compression string 示例值:ZSTD​
压缩算法。取值如下:​
  • ZSTD:ZSTD 压缩格式。​
  • Gzip:Gzip 压缩格式。​
  • Snappy:Snappy 压缩格式。​
  • NONE:无压缩。​
​
​
​
Target object 示例值:{ "Tos": { "AccessKey": { "Id": "AKLTNGRlYWNiMzJhMTYyNGEzMmIxNzg0YjQ1OGFi********" }, "AuthType": "ACCESS_KEY", "Uri": "tos://test/" }, "Type": "TOS" }​
目标存储配置。​
Type string 示例值:TOS​
目标类型。​
​
Tos object 示例值:{ "AccessKey": { "Id": "AKLTNGRlYWNiMzJhMTYyNGEzMmIxNzg0Y*****************" }, "AuthType": "ACCESS_KEY", "Uri": "tos://test/" }​
TOS 目标配置。​
Uri string 示例值:tos://test/​
TOS URI。​
​
AuthType string 示例值:ACCESS_KEY​
固定为 ACCESS_KEY。​
​
AccessKey object 示例值: "Id": "AKLTNGRlYWNiMzJhMTYyNGEzMmIxNzg0YjQ1O**********" }​
访问凭证。​
说明​
如何获取 AccessKey ID 及 AccessKey Secret,请参见 Access Key(密钥)管理。​
Id string 示例值:AKLTNGRlYWNiMzJhMTYyNGEzMmIxNz*******************​
AccessKey ID。​
​
Secret string 示例值:*********​
AccessKey Secret。​
​
​
​
​
Reason string​
失败或取消原因。​
​
CreateTime string 示例值:2026-08-24T09:10:32.976Z​
创建时间。​
​
UpdateTime string 示例值:2026-08-24T09:10:32.976Z​
最近更新时间。​
​
CompleteTime string 示例值:2026-08-24T09:10:32.976Z​
完成时间。​
​
SnapshotTime string 示例值:2026-08-24T09:10:32.976Z​
快照时间。​
​
ExpireTime string 示例值:2026-08-24T09:10:32.976Z​
结果过期时间。​
​
ExportTaskName string​
导出任务名称。​
​
InstanceId string 示例值:tidb-cd4a36******​
所属实例 ID。​
​
​
​
​
请求示例​
​
POST /?Action=CreateExportTask&Version=2026-06-30 HTTP/1.1​
Accept: application/json​
Content-Type: application/json​
Host: tidb.cn-beijing.volcengineapi.com​
X-Date: 20260728T000000Z​
Authorization: HMAC-SHA256 Credential=AK****/20260728/cn-beijing/tidb/request, SignedHeaders=accept;content-type;host;x-date, Signature=****​
​
{​
"ProjectName": "default",​
"InstanceId": "tidb-cd4a36******",​
"ExportTaskName": "export1",​
"ExportOptions": {​
"FileType": "SQL",​
"Compression": "ZSTD",​
"Filter": {​
"Table": {​
"Patterns": [​
"test.*"​
]​
}​
}​
},​
"Target": {​
"Type": "TOS",​
"Tos": {​
"Uri": "tos://test/",​
"AuthType": "ACCESS_KEY",​
"AccessKey": {​
"Id": "AKLTN******hMTYyNGEzMmIxNzg0YjQ******",​
"Secret": "TWpV******R0UzT0Rka05HTTFOVGxoWTJaaU1XWTV******"​
}​
}​
}​
}​
​
返回示例​
​
{​
"ResponseMetadata": {​
"RequestId": "202610261147534F232BDAB7B1EB0CAED5-******",​
"Action": "CreateExportTask",​
"Version": "2026-06-30",​
"Service": "tidb",​
"Region": "cn-beijing"​
},​
"Result": {​
"Export_": {​
"InstanceId": "tidb-cd4a36******",​
"CreateTime": "2026-10-26T03:47:54.045Z",​
"ExportId": "exp-3lqt4545jzfyna5dwcf6******",​
"ExportOptions": {​
"Compression": "ZSTD",​
"FileType": "SQL",​
"Filter": {​
"Table": {​
"Patterns": [​
"test.*"​
]​
}​
}​
},​
"ExportTaskName": "export1",​
"SnapshotTime": "2026-10-26T03:47:53.268Z",​
"State": "RUNNING",​
"Target": {​
"Tos": {​
"AccessKey": {​
"Id": "AKLTN*********IxNzg0YjQ1OGFiMm***"​
},​
"AuthType": "ACCESS_KEY",​
"Uri": "tos://test/"​
},​
"Type": "TOS"​
}​
}​
}​
}​
​
错误码​
下表为您列举了该接口与业务逻辑相关的错误码。公共错误码请参见公共错误码文档。​
​
状态码​
错误码​
错误信息​
说明​
400​
AuditLogDisabled​
Audit logging is disabled for the specified cluster.​
指定集群未开启审计日志。​
400​
AuditLogInvalidParameter​
The audit log request is invalid: %s​
审计日志请求参数无效:%s​
400​
DefaultPrivateEndpointCannotBeDeleted​
The default private endpoint %s cannot be deleted from the allowlist.​
默认私网终端节点 %s 不能从白名单中删除。​
400​
DefaultPrivateEndpointCannotBeReplaced​
The default private endpoint %s cannot be replaced. Only its allowlist rule name can be changed.​
默认私网终端节点 %s 不支持替换,只能修改其白名单规则名称。​
400​
PrivateEndpointServiceMismatch​
The specified private endpoint %s is not connected to the TiDB endpoint service for this cluster.​
私网终端节点 %s 未连接到当前集群对应的 TiDB 终端节点服务。​
400​
InvalidPrivateEndpoint​
The specified private endpoint %s is invalid: %s.​
私网终端节点 %s 无效:%s。​
400​
DisplayNameNotUnique​
Cluster names must be unique. The current name [%s] already exists. Please use a different name.​
集群名称需保持唯一,当前名称%s已存在,请使用其他名称。​
400​
QuotaExceeded​
The account quota has been exceeded.​
账号配额已超限。​
400​
OperationUnsupported​
The operation is unsupported for the specified cluster. %s​
操作不支持。%s​
400​
InvalidParameterFormat​
The input parameter is not valid.​
请求参数格式错误。​
400​
UnsupportedParameter​
The specified parameter %s is not support.​
当前参数%s值不支持。​
400​
InvalidParameter​
The specified parameter %s is not valid.​
参数%s值无效。​
400​
MissingParameter​
The input parameter %s that is mandatory for processing this request is not supplied.​
缺少%s参数。​
400​
MissingParameter​
The input parameter %s that is mandatory for processing this request is not supplied.​
缺少%s参数。​
400​
InvalidParameter​
The specified parameter %s is not valid.​
参数%s值无效。​
400​
UnsupportedParameter​
The specified parameter %s is not support.​
当前参数%s值不支持。​
400​
InvalidParameterFormat​
The input parameter is not valid.​
请求参数格式错误。​
400​
OperationUnsupported​
The operation is unsupported for the specified cluster. %s​
操作不支持。%s​
400​
QuotaExceeded​
The account quota has been exceeded.​
账号配额已超限。​
400​
DisplayNameNotUnique​
Cluster names must be unique. The current name [%s] already exists. Please use a different name.​
集群名称需保持唯一,当前名称%s已存在,请使用其他名称。​
400​
InvalidPrivateEndpoint​
The specified private endpoint %s is invalid: %s.​
私网终端节点 %s 无效:%s。​
400​
PrivateEndpointServiceMismatch​
The specified private endpoint %s is not connected to the TiDB endpoint service for this cluster.​
私网终端节点 %s 未连接到当前集群对应的 TiDB 终端节点服务。​
400​
DefaultPrivateEndpointCannotBeReplaced​
The default private endpoint %s cannot be replaced. Only its allowlist rule name can be changed.​
默认私网终端节点 %s 不支持替换,只能修改其白名单规则名称。​
400​
DefaultPrivateEndpointCannotBeDeleted​
The default private endpoint %s cannot be deleted from the allowlist.​
默认私网终端节点 %s 不能从白名单中删除。​
400​
AuditLogInvalidParameter​
The audit log request is invalid: %s​
审计日志请求参数无效:%s​
400​
AuditLogDisabled​
Audit logging is disabled for the specified cluster.​
指定集群未开启审计日志。​
403​
PermissionDenied​
You are not authorized to perform this operation.​
没有权限执行该操作。​
403​
PermissionDenied​
You are not authorized to perform this operation.​
没有权限执行该操作。​
404​
PrivateEndpointNotFound​
The specified private endpoint %s does not exist.​
未找到私网终端节点 %s。​
404​
AuditLogFilterRuleNotFound​
The specified audit log filter rule %s does not exist.​
未找到审计日志过滤规则 %s。​
404​
RestoreJobNotFound​
No restore job found for the specified cluster.​
未找到恢复任务。​
404​
TableNotFound​
The specified table %s does not exist.​
未找到Table %s​
404​
PrivateEndpointAllowlistRuleNotFound​
The private endpoint allowlist rule for VpcEndpointId %s does not exist.​
未找到 VpcEndpointId 为 %s 的私网白名单规则。​
404​
BranchNotFound​
The specified branch %s does not exist.​
未找到BranchId %s。​
404​
ClusterNotFound​
The specified cluster %s does not exist.​
未找到ClusterId %s。​
404​
ProjectNotFound​
The specified project %s does not exist.​
未找到Project %s。​
404​
ProjectNotFound​
The specified project %s does not exist.​
未找到Project %s。​
404​
ClusterNotFound​
The specified cluster %s does not exist.​
未找到ClusterId %s。​
404​
BranchNotFound​
The specified branch %s does not exist.​
未找到BranchId %s。​
404​
PrivateEndpointNotFound​
The specified private endpoint %s does not exist.​
未找到私网终端节点 %s。​
404​
PrivateEndpointAllowlistRuleNotFound​
The private endpoint allowlist rule for VpcEndpointId %s does not exist.​
未找到 VpcEndpointId 为 %s 的私网白名单规则。​
404​
TableNotFound​
The specified table %s does not exist.​
未找到Table %s​
404​
RestoreJobNotFound​
No restore job found for the specified cluster.​
未找到恢复任务。​
404​
AuditLogFilterRuleNotFound​
The specified audit log filter rule %s does not exist.​
未找到审计日志过滤规则 %s。​
409​
AuditLogFilterRuleAlreadyExists​
The audit log filter rule %s already exists.​
审计日志过滤规则 %s 已存在。​
409​
PrivateEndpointNotAvailable​
The specified private endpoint %s is not available. Current status: %s.​
私网终端节点 %s 当前不可用,当前状态:%s。​
409​
PrivateEndpointAllowlistRuleAlreadyExists​
The private endpoint allowlist rule for VpcEndpointId %s already exists.​
VpcEndpointId 为 %s 的私网白名单规则已存在。​
409​
PrivateEndpointAllowlistRuleAlreadyExists​
The private endpoint allowlist rule for VpcEndpointId %s already exists.​
VpcEndpointId 为 %s 的私网白名单规则已存在。​
409​
PrivateEndpointNotAvailable​
The specified private endpoint %s is not available. Current status: %s.​
私网终端节点 %s 当前不可用,当前状态:%s。​
409​
AuditLogFilterRuleAlreadyExists​
The audit log filter rule %s already exists.​
审计日志过滤规则 %s 已存在。​
500​
InternalError​
The request processing has failed due to some unknown error, exception or failure.​
内部错误。​
500​
ServiceBusy​
The system is busy, please try again later.​
系统繁忙,请稍后重试。​
500​
TiDBError​
err from tidb: %s​
TiDB错误:%s。​
500​
InternalError​
The request processing has failed due to some unknown error, exception or failure.​
内部错误。​
500​
TiDBError​
err from tidb: %s​
TiDB错误:%s​
500​
ServiceBusy​
The system is busy, please try again later.​
系统繁忙,请稍后重试。​
503​
ServiceUnavailable​
The request has failed due to a temporary failure of the server.​
当前服务暂时不可用。​
503​
ServiceUnavailable​
The request has failed due to a temporary failure of the server.​
当前服务暂时不可用。​
​
​
最近更新时间:2026.10.30 11:06:00
这个页面对您有帮助吗?
有用
有用
无用
无用