Ask HN: Archive a MySQL database

Re:Ask HN: Archive a MySQL database by slater on Monday January 19, 2009 @12:10AM (#440082)

You could use PHPMyAdmin:

Go to the "export" tab and use the "Save as file" option

[ Parent | on HN ]

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 ]