Hi!
>>>>> "Rich" == Rich Foreman <[EMAIL PROTECTED]> writes: Rich> Hi, Rich> I have two servers (one remotely hosted, and one locally) that I would like Rich> to have the same database on for backup purposes. Rich> I would like the two databases to synchronize automatically and all the time. Rich> Is there currently any way to do this? Yes, as long as the updates are not conflicting. In this case you 'just' need set up both servers as 'masters' and then set them to be a slave of the other. Please consult the MySQL replication chapter in the manual for how to do this. Rich> Remote server: FreeBSD running MySQL 3.23.40 Rich> Local Server: WinXP with phpTriad and MySQL 3.23.32 (I am changing this Rich> server to foxserv with latest MySQL tomorrow) Rich> Databases have same name and user/password combos Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --------------------------------------------------------------------- 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
