exporting-rds-to-s3

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

Exporting RDS/Aurora to S3

将RDS/Aurora导出至S3

Overview

概述

Domain expertise for exporting Amazon RDS and Aurora database snapshots to Amazon S3 in Apache Parquet format. Covers the full workflow: snapshot identification or creation, IAM role and KMS encryption setup, S3 bucket preparation, export task initiation, progress monitoring, data verification, and post-export access guidance for analytics services like Athena, Glue, and Redshift Spectrum.

本内容专注于将Amazon RDS和Aurora数据库快照以Apache Parquet格式导出至Amazon S3的领域知识，涵盖完整工作流程：快照识别或创建、IAM角色与KMS加密配置、S3存储桶准备、导出任务启动、进度监控、数据验证，以及导出后供Athena、Glue和Redshift Spectrum等分析服务访问的指导。

Export an RDS or Aurora snapshot to S3

将RDS或Aurora快照导出至S3

To export a database snapshot to S3 with proper IAM roles, encryption, and monitoring, follow the procedure exactly. See RDS to S3 export procedure.

如需在配置正确IAM角色、加密和监控的前提下将数据库快照导出至S3，请严格遵循以下步骤。详情请参阅RDS至S3导出流程。

Troubleshooting

故障排查

Database not found

数据库未找到

Verify the database identifier spelling, case, and region. For Aurora, use

describe-db-clusters

instead of

describe-db-instances

请验证数据库标识符的拼写、大小写和区域。对于Aurora，请使用

describe-db-clusters

而非

describe-db-instances

。

Export not supported

导出不被支持

Snapshot export supports MySQL, PostgreSQL, MariaDB, Aurora MySQL, and Aurora PostgreSQL only. Oracle and SQL Server are not supported.

快照导出仅支持MySQL、PostgreSQL、MariaDB、Aurora MySQL和Aurora PostgreSQL。Oracle和SQL Server暂不支持。

IAM role permission errors

IAM角色权限错误

Ensure the role trust policy allows

export.rds.amazonaws.com

with

aws:SourceAccount

and

aws:SourceArn

conditions for confused deputy protection, and has S3 PutObject and KMS permissions. Wait 10–15 seconds after role creation for propagation.

确保角色信任策略允许

export.rds.amazonaws.com

，并配置

aws:SourceAccount

和

aws:SourceArn

条件以防范混淆代理问题，同时该角色需具备S3 PutObject和KMS权限。角色创建后请等待10-15秒以确保权限生效。

Export stuck or failed

导出停滞或失败

Check the export task status for failure reasons. Common causes: S3 bucket deleted, IAM role modified, or KMS key disabled during export. See the full procedure for detailed troubleshooting.

请查看导出任务状态以获取失败原因。常见原因包括：导出过程中S3存储桶被删除、IAM角色被修改或KMS密钥被禁用。详细故障排查请参阅完整流程。