View Full Version : How to synchronize two MySQL Databases together

03-09-2007, 12:55 PM

I was wondering how to synchronize my two different MySQL Databases together. For example, when my main database get's some new info, it will be synchronized with my backup database, which is located on another server.

Any help will be much appreciated.

03-09-2007, 03:10 PM
look into MASTER/SLAVE replication. There is a chapter (http://dev.mysql.com/doc/refman/5.0/en/replication.html) on replication in the manual, or you could search the web.

03-09-2007, 08:42 PM

I'll be sure to check that out. If I still need more help I'll post here, untill then, don't bother wasting your time helping me, since I might already have figured it out. And in case I do, I'll post it here.

Thanks again for the help.