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
Charles,
1. With mysqldump. mysqldump -hmysql-inst1 mysql | mysql -hmysql-inst2 mysql
2. With pt-table-sync from Percona Toolkit if you need something more
sophisticated.
On Fri, Mar 16, 2012 at 1:27 PM, Brown, Charles cbr...@bmi.com wrote:
Can someone instruct me on how to sync mysql.user
to sync mysql.user table between to two mysql instances
Charles,
1. With mysqldump. mysqldump -hmysql-inst1 mysql | mysql -hmysql-inst2 mysql
2. With pt-table-sync from Percona Toolkit if you need something more
sophisticated.
On Fri, Mar 16, 2012 at 1:27 PM, Brown, Charles cbr...@bmi.com wrote
. 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
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
- 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