Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Stuck in Preparing-data-migration status while restoring rds db snapshot from s3

0

I have exported my rds snapshot to s3 with "export to s3". And now I want my old db and I restore back from s3 with " restore from s3 " of rds console. After 1day and 1night later, rds status is still "Preparing-data-migration" . It takes a long time to restore. My snapshot size from s3 is only 2GB. Please help me.

Topics
AnalyticsMigration & ModernizationDatabaseStorage
Tags
Amazon Relational Database ServiceAmazon Simple Storage Service
Language
English
asked 2 years ago735 views
1 Answer
0

You can't restore exported snapshot data from S3 to a new DB instance. Please see the limitations of DB snapshot exports.

DB snapshot and Snapshot export are not the same. You can't use the snapshot exports for restoring a DB instance. When you export a DB snapshot, Amazon RDS extracts data from the snapshot and stores it in an Amazon S3 bucket. The data is stored in an Apache Parquet format. The exported data can be accessed by analytical tools like Amazon Athena or Amazon Redshift Spectrum.

answered 2 years ago
EXPERT
reviewed 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content