Quote:
Originally Posted by DaFace
Do you have some nifty way of doing it, or just manually move tables over every once in a while? It seems like it'd be a pain, but it's possible.
|
There are plenty of nifty ways of doing it. You (or somebody like myself) could write PHP scripts to move all records in 1 MySQL DB to another if they're older than a given date. That would completely automate the process. Could even provide logs of all the stuff that was archived and keep a sticky in the forum somewhere that shows people updates on archived threads.
Another thing you could do is use a tool like Navicat, a MySQL manager, and setup automated backup/archive rules within it. It'd still be automatic but it would run from a client instead of the server.