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 Methods 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 information is consistent when viewed from either side of the link at all times? Paul. o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~ o DISCLAIMER THE INFORMATION CONTAINED IN THIS COMMUNICATION IS CONFIDENTIAL AND MAY BE LEGALLY PRIVILEGED.IT IS INTENDED SOLELY FOR USE OF THE INDIVIDUAL OR ENTITY TO WHOM IT IS ADDRESSED AND OTHERS AUTHORIZED TO RECEIVE IT. IF YOU ARE NOT THE INTENDED RECIPIENT YOU ARE HEREBY NOTIFIED THAT ANY DISCLOSURE, COPYING, DISTRIBUTION OR TAKING ACTION IN RELIANCE OF THE CONTENTS OF THIS INFORMATION IS STRICTLY PROHIBITED AND MAY BE UNLAWFUL . NEW VISION PRINTING AND PUBLISHING LIMITED IS NEITHER LIABLE FOR THE PROPER, COMPLETE TRANSMISSION OF THE INFORMATION CONTAINED IN THIS COMMUNICATION, ANY DELAY IN ITS RECEIPT OR THAT THE MAIL IS VIRUS-FREE -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]