Steve: > I suppose maybe making this a slave table > to the other > server... nah... lots of work there
Setting your local server to be a slave of the remote server is not too hard and would be a MUCH better solution. The steps are fairly staightforward: 1. Add a slave user to the remote database 2. Tell the remote server to create a binary log 3. Tell the local server to be a slave of the remote 4. Start the slave It should take less than 1 hour to set it up. I have done it many times. It is probably not as hard as you are thinking it will be. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org