Re: synchronizing mysql database in two diferrent places

2004-10-31 Thread Karam Chand
Hello, You might try MySQL's inbuilt replication feature. If you want a more simple approach, might take a look at SQLyog's Data Sync Wizard. More information can be found at http://www.webyog.com I think they have a article on the same subject in SitePoint. You might google it. Karam ---

Re: synchronizing mysql database in two diferrent places

2004-10-30 Thread Gleb Paharenko
Hi. MySQL replication currently does not support any locking protocol between master and slave to guarantee the atomicity of a distributed (cross-server) update. See: http://dev.mysql.com/doc/mysql/en/Replication_FAQ.html Eko Budiharto [EMAIL PROTECTED] wrote: Hi, I a facing a

synchronizing mysql database in two diferrent places

2004-10-29 Thread Eko Budiharto
Hi, I a facing a situation where I have two database server in two different places that has exactly the same database. The thing is if the database is modified in either one of the places, both database has to be updated lively. Can someone tell me who done this already? Please help. I am