RE: Database Synchronisation Methods

2008-04-08 Thread Rajesh Mehrotra
Hi Paul, You need to set up replication. Check http://dev.mysql.com/doc/refman/5.0/en/replication.html -Raj. -Original Message- From: Paul Ikanza [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 08, 2008 1:05 PM To: 'mysql@lists.mysql.com' Subject: Database Synchronisation M

Database Synchronisation Methods

2008-04-08 Thread Paul Ikanza
Hi All, I am trying to figure out the best way to do database synchronisation. I have my database at the head office and the application runs, partly at remote/branch office. I am considering having a copy of the database there but how can I have it synchronise in real time so that the inform