Replicate data from one MySQL DB to another
Posted on 2011-02-22
I have two servers, hosted by different companies. Both running MySQL. I was wondering if there's a script that could run automatically that would transfer all of the data in the DB from one server over to the other. Preferable something that ran automatically, like every 4 hours. The table structure would be the same on both servers.