From: Andrew Moore Date: October 18 2011 10:47am Subject: Re: Synchronize two mysql servers (single user, only one server (but not both) can be changed at any given time) List-Archive: http://lists.mysql.com/mysql/226082 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=f46d0444ee9be21dd804af907249 --f46d0444ee9be21dd804af907249 Content-Type: text/plain; charset=ISO-8859-1 As Johan describes, replication is the way. If that's not an option due to connectivity between the hosts you could arrange for a logical dump to be copied and restored. I would certainly opt for replication in your situation. A On Tue, Oct 18, 2011 at 7:02 AM, Johan De Meersman wrote: > ----- Original Message ----- > > From: "Peng Yu" > > > > Suppose I have two servers (one on mac and one on ubuntu), at any > > time I only change one server but not both servers. After I have done > > > > I think that probably it is OK to synchronize these two servers at > > the database file level using something like unison. However, this will > > It's not generally a good idea to copy database files across platforms, let > alone possibly different versions of the mysql server. > > You probably want to set up master-master replication, which should work > fine across platforms. If you are sure that you'll never change the (same) > data on both sides concurrently, there is pretty much nothing that can go > wrong. > > Have a look at the online documentation at mysql.com, it should be your > first stop for everything :-) > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=eroomydna@stripped > > --f46d0444ee9be21dd804af907249--