Neil Tompkins schrieb am Donnerstag, 16. August 2001, 14:20:07:
> Below is a message I posted earlier. But what I'm really looking for is
> does MySQL provide synchrosisation of data. If so, can someone point me in
> the right direction
Well, I'll give it another try. The answer is Yes and No.
Yes: you can replicate databases. You set up one database as a
master and any number of other as slaves. These slaves may reside
on the same machine or on any number of other machines. It is a
one-way communication. The master is used to change data, the
slaves to read data only. Very clean concept, seems to work well,
although I didn't try it personally yet.
No: as far as I understand your question, you want to synchronize
data between your local machine and the webserver in a two way
process. This is something I do regularly for some reason, i.e.
users insert/delete/update the web database, I
insert/delete/update some data locally for testing and later
addition to the web. I don't see any way to automate such a two
way communication, and it is certainly not possible with the
replication mechanisms at hand.
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php