Hello johan Here is what did the trick for me: 1. in mysql-inst1, I created like table called test.user 2. I used mysqldump to pipe test.user table from mysql-inst1 to mysql-inst2 3. in mysql-inst2, I did insert into mysql.user select from test.user
We are migrating from master-slave replication to mysql cluster. My sysprog person has been doing all the work. I was told in a clustered environment, replication should happen automatically -- I'm still waiting for my mysql.user table to automatically syncs itself. A long wait it has been. Thanks -----Original Message----- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Friday, March 16, 2012 5:00 PM To: Baron Schwartz Cc: MySql Subject: Re: how to sync mysql.user table between to two mysql instances ----- Original Message ----- > From: "Baron Schwartz" <ba...@xaprb.com> > > 1. With mysqldump. mysqldump -hmysql-inst1 mysql | mysql > -hmysql-inst2 mysql And then, of course, issue a FLUSH PRIVILEGES on mysql-inst2 :-) -- 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 ******************************************** This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. ******************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
