0
votes
0answers
57 views

how to archive old entries from mysql on rds

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 ...
0
votes
3answers
249 views

Using MySQL InnoDB as an Archive

My site has a main MySQL InnoDB table that it does most of its work on. New rows get inserted at a rate of 1 million per week, and rows older than a week gets moved over to an archive table on a daily ...
0
votes
2answers
823 views

Delete and archive old data from several related tables

Our schema looks like this: table tblTrip: stores start and end trip date and time table tblTripData: keeps all the trip data table tblTripEvent: stores events related to the particular trip. Then ...
1
vote
3answers
260 views

Design for archiving a sorted list (with ability for a few INSERT)

I have a somewhat static sorted list of words which I want to save in a database table: -- simplified! -- Note: the rank/order of each item is NOT calculable from other values! CREATE table words ( ...