News for hackers. Stuff that matters.

A comment on Ask HN: Archive a MySQL database. Parent comment

Re:Ask HN: Archive a MySQL database by wenbert on Monday January 19, 2009 @12:16AM (#440089)
Exporting the database? But then I would still have a lot of rows in the database. What I was trying to say is that I archive the "old" records in the database and still have the currently used ones available. How do you go about this?
[ Parent | on HN ]
Re:Ask HN: Archive a MySQL database by elijahbuck on Monday January 19, 2009 @01:17AM (#440138)
What is your criteria for a record being "old"? Once you've established your criteria, just archive the database as it is now and then drop the rows that match your oldness criteria.
[ Parent | on HN ]
Re:Ask HN: Archive a MySQL database by wenbert on Monday January 19, 2009 @01:50AM (#440160)
I imagine that I have also to query down to the dependent tables?
[ Parent | on HN ]