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
a year ago
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.

Relevant content