Point-In-TIme data restore on Amazon RDS

Question

I hosted the MySQL database on amazon rds. I accidentally deleted some of the records from a very important table and would like to recover them. How should I recover data without taking any downtime? How do I use point-in-time data recovery?

Answer 1

Point in time recovery grants you access to create an additional RDS instance, based on the data as it existed on your instance at any specific point in time you choose between the oldest available automated backup. RDS preserves the snapshots as well as a complete, timestamped log of everything that changed between the snapshots. RDS will automatically load the most recent snapshot that is earlier than the point-in-time you select.

Perform this recovery at any point between 10:00 and 10:30 -- a point in time when the records were in your database to solve your issue of deleted items mentioned in your question.