AWS RDS:从S3存储桶中的sql文件导入数据 [英] AWS RDS: import data from sql file in S3 bucket

问题描述

我有一个作为sql文件存储在s3存储桶中的数据库备份.如何将这个文件直接导入到Aurora RDS中而不将其下载到PC上并手动导入?

I have a database backup as sql file stored in s3 bucket. How can I import this file to the Aurora RDS directly without downloading it to my PC and import it manually?

推荐答案

• 如果您的数据是有效的SQL转储，则可以在创建新的Aurora实例时指定其S3密钥(通过AWS Console向导或通过具有--s3-bucket-name ... --s3-ingestion-role-arn ... --s3-prefix ...的CLI).
• 如果要导入CSV，XML或类似的内容，Aurora MySQL 1.8+为此提供了LOAD DATA FROM S3/LOAD XML FROM S3查询.
• If your data is a valid SQL dump, you can specify its S3 key while creating a new Aurora instance (via the AWS Console wizard or via CLI with --s3-bucket-name ... --s3-ingestion-role-arn ... --s3-prefix ... etc.).
• If you want to import CSV, XML or something like that, Aurora MySQL 1.8+ is providing the LOAD DATA FROM S3/LOAD XML FROM S3 query for this purpose.

这篇关于AWS RDS:从S3存储桶中的sql文件导入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！