encrypted db snapshot restore from S3 not working AWS RDS(mysql) console in an S3 bucket.

Question

Hello, I've an encrypted db snapshot thats generated through AWS RDS console in an S3 bucket. When I attempted to restore the dB snapshot from S3, I received an error saying "Files from the specified Amazon S3 bucket are encrypted. Restoring from encrypted S3 object is not available". If restoring from an encrypted backup from S3 isn't allowed, why did AWS gave us option of backing up with an encryption key?

Is there a way to recover the data from the S3 bucket to a new database? Please provide me recommendations on how to restore this encrypted database?

Vetrivel · Answer

It is not possible to restore a snapshot back to RDS from an S3 bucket. The "Export to Amazon S3" feature, does not copy the snapshot itself. When you export a DB snapshot, Amazon RDS extracts data from the snapshot and stores it in an Amazon S3 bucket in your account. The data is stored in an Apache Parquet format that is compressed and consistent.

After the data is exported, you can analyze the exported data directly through tools like Amazon Athena or Amazon Redshift Spectrum [1]. The feature of export to S3 is to analyze the exported data directly through tools like Amazon Athena or Amazon Redshift Spectrum, and it cannot be used with "Restore from S3" option.

You can't restore from an encrypted backup in the Amazon S3 bucket.[2].

### Reference:
> [1] Exporting DB snapshot data to Amazon S3 - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ExportSnapshot.html

> [2] Restoring a backup into a MySQL DB instance - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.html

encrypted db snapshot restore from S3 not working AWS RDS(mysql) console in an S3 bucket.

Reference:

Relevant content