StartExportTask - Amazon Relational Database Service
Request ParametersResponse ElementsErrorsSee Also
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

StartExportTask

Starts an export of DB snapshot or DB cluster data to Amazon S3. The provided IAM role must have access to the S3 bucket.

You can't export snapshot data from Db2 or RDS Custom DB instances.

You can't export cluster data from Multi-AZ DB clusters.

For more information on exporting DB snapshot data, see Exporting DB snapshot data to Amazon S3 in the Amazon RDS User Guide or Exporting DB cluster snapshot data to Amazon S3 in the Amazon Aurora User Guide.

For more information on exporting DB cluster data, see Exporting DB cluster data to Amazon S3 in the Amazon Aurora User Guide.

Request Parameters

For information about the parameters that are common to all actions, see Common Parameters.

ExportTaskIdentifier

A unique identifier for the export task. This ID isn't an identifier for the Amazon S3 bucket where the data is to be exported.

Type: String

Required: Yes

IamRoleArn

The name of the IAM role to use for writing to the Amazon S3 bucket when exporting a snapshot or cluster.

In the IAM policy attached to your IAM role, include the following required actions to allow the transfer of files from Amazon RDS or Amazon Aurora to an S3 bucket:

  • s3:PutObject*

  • s3:GetObject*

  • s3:ListBucket

  • s3:DeleteObject*

  • s3:GetBucketLocation

In the policy, include the resources to identify the S3 bucket and objects in the bucket. The following list of resources shows the Amazon Resource Name (ARN) format for accessing S3:

  • arn:aws:s3:::your-s3-bucket

  • arn:aws:s3:::your-s3-bucket/*

Type: String

Required: Yes

KmsKeyId

The ID of the Amazon KMS key to use to encrypt the data exported to Amazon S3. The Amazon KMS key identifier is the key ARN, key ID, alias ARN, or alias name for the KMS key. The caller of this operation must be authorized to run the following operations. These can be set in the Amazon KMS key policy:

  • kms:Encrypt

  • kms:Decrypt

  • kms:GenerateDataKey

  • kms:GenerateDataKeyWithoutPlaintext

  • kms:ReEncryptFrom

  • kms:ReEncryptTo

  • kms:CreateGrant

  • kms:DescribeKey

  • kms:RetireGrant

Type: String

Required: Yes

S3BucketName

The name of the Amazon S3 bucket to export the snapshot or cluster data to.

Type: String

Required: Yes

SourceArn

The Amazon Resource Name (ARN) of the snapshot or cluster to export to Amazon S3.

Type: String

Required: Yes

ExportOnly.member.N

The data to be exported from the snapshot or cluster. If this parameter isn't provided, all of the data is exported.

Valid Values:

  • database - Export all the data from a specified database.

  • database.table table-name - Export a table of the snapshot or cluster. This format is valid only for RDS for MySQL, RDS for MariaDB, and Aurora MySQL.

  • database.schema schema-name - Export a database schema of the snapshot or cluster. This format is valid only for RDS for PostgreSQL and Aurora PostgreSQL.

  • database.schema.table table-name - Export a table of the database schema. This format is valid only for RDS for PostgreSQL and Aurora PostgreSQL.

Type: Array of strings

Required: No

S3Prefix

The Amazon S3 bucket prefix to use as the file name and path of the exported data.

Type: String

Required: No

Response Elements

The following elements are returned by the service.

ExportOnly.member.N

The data exported from the snapshot or cluster.

Valid Values:

  • database - Export all the data from a specified database.

  • database.table table-name - Export a table of the snapshot or cluster. This format is valid only for RDS for MySQL, RDS for MariaDB, and Aurora MySQL.

  • database.schema schema-name - Export a database schema of the snapshot or cluster. This format is valid only for RDS for PostgreSQL and Aurora PostgreSQL.

  • database.schema.table table-name - Export a table of the database schema. This format is valid only for RDS for PostgreSQL and Aurora PostgreSQL.

Type: Array of strings

ExportTaskIdentifier

A unique identifier for the snapshot or cluster export task. This ID isn't an identifier for the Amazon S3 bucket where the data is exported.

Type: String

FailureCause

The reason the export failed, if it failed.

Type: String

IamRoleArn

The name of the IAM role that is used to write to Amazon S3 when exporting a snapshot or cluster.

Type: String

KmsKeyId

The key identifier of the Amazon KMS key that is used to encrypt the data when it's exported to Amazon S3. The KMS key identifier is its key ARN, key ID, alias ARN, or alias name. The IAM role used for the export must have encryption and decryption permissions to use this KMS key.

Type: String

PercentProgress

The progress of the snapshot or cluster export task as a percentage.

Type: Integer

S3Bucket

The Amazon S3 bucket where the snapshot or cluster is exported to.

Type: String

S3Prefix

The Amazon S3 bucket prefix that is the file name and path of the exported data.

Type: String

SnapshotTime

The time when the snapshot was created.

Type: Timestamp

SourceArn

The Amazon Resource Name (ARN) of the snapshot or cluster exported to Amazon S3.

Type: String

SourceType

The type of source for the export.

Type: String

Valid Values: SNAPSHOT | CLUSTER

Status

The progress status of the export task. The status can be one of the following:

  • CANCELED

  • CANCELING

  • COMPLETE

  • FAILED

  • IN_PROGRESS

  • STARTING

Type: String

TaskEndTime

The time when the snapshot or cluster export task ended.

Type: Timestamp

TaskStartTime

The time when the snapshot or cluster export task started.

Type: Timestamp

TotalExtractedDataInGB

The total amount of data exported, in gigabytes.

Type: Integer

WarningMessage

A warning about the snapshot or cluster export task.

Type: String

Errors

For information about the errors that are common to all actions, see Common Errors.

DBClusterNotFoundFault

DBClusterIdentifier doesn't refer to an existing DB cluster.

HTTP Status Code: 404

DBClusterSnapshotNotFoundFault

DBClusterSnapshotIdentifier doesn't refer to an existing DB cluster snapshot.

HTTP Status Code: 404

DBSnapshotNotFound

DBSnapshotIdentifier doesn't refer to an existing DB snapshot.

HTTP Status Code: 404

ExportTaskAlreadyExists

You can't start an export task that's already running.

HTTP Status Code: 400

IamRoleMissingPermissions

The IAM role requires additional permissions to export to an Amazon S3 bucket.

HTTP Status Code: 400

IamRoleNotFound

The IAM role is missing for exporting to an Amazon S3 bucket.

HTTP Status Code: 404

InvalidExportOnly

The export is invalid for exporting to an Amazon S3 bucket.

HTTP Status Code: 400

InvalidExportSourceState

The state of the export snapshot is invalid for exporting to an Amazon S3 bucket.

HTTP Status Code: 400

InvalidS3BucketFault

The specified Amazon S3 bucket name can't be found or Amazon RDS isn't authorized to access the specified Amazon S3 bucket. Verify the SourceS3BucketName and S3IngestionRoleArn values and try again.

HTTP Status Code: 400

KMSKeyNotAccessibleFault

An error occurred accessing an Amazon KMS key.

HTTP Status Code: 400

See Also

For more information about using this API in one of the language-specific Amazon SDKs, see the following: