I have a Python application that is using MySQL to store records of transactions....
about 3 tables with ~1k records each.
How can I periodically copy the records off the production on to an "archive server"? I
would like to this for two reasons:
1) To run data-mining queries on a copy of the live dataset without the risk of
overloading the production server.
2) To maintain an addional set of "historical tables" that contain all the records the
system has ever had, even after they are dropped from the "live" tables.
How should I go about doing this?