RE: how to sync mysql.user table between to two mysql instances

2012-03-17 Thread Brown, Charles
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

how to sync mysql.user table between to two mysql instances

2012-03-16 Thread Brown, Charles
Can someone instruct me on how to sync mysql.user table between to two mysql instances. In other words, I wouild like to copy mysql.user from mysql-inst1 to mysql-inst2 + Thanks This message is intended only for the use of the Addressee and may

Re: how to sync mysql.user table between to two mysql instances

2012-03-16 Thread Baron Schwartz
table between to two mysql instances. In other words, I wouild like to copy mysql.user from mysql-inst1 to mysql-inst2 + -- Baron Schwartz Win free MySQL conference tickets! http://goo.gl/mvZ4W -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: how to sync mysql.user table between to two mysql instances

2012-03-16 Thread David Lerer
: Can someone instruct me on how to sync mysql.user table between to two mysql instances. In other words, I wouild like to copy mysql.user from mysql-inst1 to mysql-inst2 + -- Baron Schwartz Win free MySQL conference tickets! http://goo.gl/mvZ4W -- MySQL General Mailing List For list archives

RE: how to sync mysql.user table between to two mysql instances

2012-03-16 Thread Brown, Charles
. Help me I'm running out of time. -Original Message- From: David Lerer [mailto:dle...@us.univision.com] Sent: Friday, March 16, 2012 1:36 PM To: Baron Schwartz; MySql; Brown, Charles Subject: RE: how to sync mysql.user table between to two mysql instances As a follow up question

RE: how to sync mysql.user table between to two mysql instances

2012-03-16 Thread David Lerer
To: David Lerer; Baron Schwartz; MySql Subject: RE: how to sync mysql.user table between to two mysql instances Hello David, Precisely, that's what my problem is. The users found in mysqlinst1 are not in mysqlinst2. There are about 30 users defined in inst1 and only 4 in inst2. I would like to sync

Re: how to sync mysql.user table between to two mysql instances

2012-03-16 Thread Johan De Meersman
- 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