Have a look at the Merge engine. On Sun, Oct 18, 2009 at 10:31 PM, Allen Fowler <allen.fow...@yahoo.com>wrote:
> Hello, > > 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? > > Thank you, > :) > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be > > -- That which does not kill you was simply not permitted to do so for the purposes of the plot.