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

Question

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.

Answer

You can't restore exported snapshot data from S3 to a new DB instance. Please see the [limitations of DB snapshot exports](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ExportSnapshot.html#USER_ExportSnapshot.Limits).

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.

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

Relevanter Inhalt