Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an AWS RDS MySQL DB.

I have ec2 instances and an s3. What I would like to do is only retain 60days old data and archive the rest.

I'm still new at this so I'm not really sure what to do. What is the simplest way of achieving this?

I'm planning to start from a simple strategy first and then improve my way from there. I know there are a lot of ways in doing this but with my limited knowledge I would prefer the simplest way.

share|improve this question
You want to archive data from all tables or from some specific table ? – Abdul Manaf Mar 6 '14 at 5:21
For specific tables only. Any ideas? – Ragu Diaz Mar 6 '14 at 5:29
Do you have timestamp field on those table ? Does your tables have Foreign Key Relationships ? – Abdul Manaf Mar 6 '14 at 5:31
Yes sir. They have timestamps and foreign key relationships. – Ragu Diaz Mar 6 '14 at 6:14
check out pt-archiver – akuzminsky Mar 6 '14 at 14:47

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.