You wrote: What about mysqldump? See http://www.mysql.com/doc/m/y/mysqldump.html for more info about mysqldump.
well, no, not really : site1 - has apache / php / mysql + database x site2 - has apache / php / mysql + database y site3 - has apache / php / mysql + database z at 9:00 am all databses (x,y,z) are same. during day, people at 1 update x, people at 2 update y, people at 3 update z. at (say) 23:00 , I want to put all x's changes into y and z, all y's changes into x and z, all z's changes into x and y. mysqldump x > x.dmp mysqldump y > y.dmp mysqldump z > z.dmp would require that i then do a diff of x, y and apply all < diffs to x, all > diffs to y ... and so on - it looks like an over-engineered solution to me. What I was asking is whether replication would ease my pain. David. --------------------------------------------------------------------- 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
