I accidentally rewrote RDS table with a blank table. There is no snapshot.

Question

Today while trying to access my table through API, I accidentally ran the initialization function, which rewrote my data table with a blank one. We have not set up automatic backups nor taken a snapshot of the table as of yet. I found the event in the event stream, and I am wondering if there is any way that we can recover the data from the table. It happened 20 minutes ago, and we have been trying to figure out a way.

Farzana Rahman
일 년 전
By default RDS kept automated backup. If you don't retention set time to 0, then there will have an whole database instance backup in s3. Please see this link: https://aws.amazon.com/rds/features/backup/

Answer

Unfortunatelly, you can not recover it without snapshots. If you had enabled automated snapshots, you would have used "Restore to point in time" feature, but it creates a new RDS instance. In case of using AWS Aurora, you could enable a "Backtrack" that lets you quickly rewind the DB cluster to a specific point in time, without having to create another DB cluster.

I accidentally rewrote RDS table with a blank table. There is no snapshot.

관련 콘텐츠