have a look into replication...might be what you realy need
http://dev.mysql.com/doc/mysql/en/replication.html
bastien
From: "Andri" <[EMAIL PROTECTED]>
To: "PHP DB List" <php-db@lists.php.net>
Subject: [PHP-DB] database synchronization
Date: Thu, 12 May 2005 14:09:51 +0700
Hello all, anyone can help me?
I have web based application running on php and mysql and installed on
multiple sites. The data on those sites need to be synchronized (to have
same data on every site after insert/update/delete action in each site).
Currently im using an ftp server to handle synchronization, im using
batch script to export and import data running on each site to the ftp
server. but it still is a tedious job that requires constant monitoring,
i need to have some kind of synchronization agent that can be installed
on each site. Is there any tools for that?
Andri Junardi Ahmad
IT Assistant Manager
Tauzia International Management
Wisma Adi Graha 17th floor
Jl. Jend. Gatot Subroto Kav. 56
Jakarta 12950, Indonesia
t. +62 21 5296 0490 f. +62 21 5296 0491
[EMAIL PROTECTED]
<http://www.tauzia.com>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php