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"
>
> 1. With mysqldump. mysqldump -hm
- Original Message -
> From: "Baron Schwartz"
>
> 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 dri
6, 2012 2:59 PM
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 ins
dious. 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 ques
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 wrote:
> Can some
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 wrote:
> Can someone instruct me on how to sync mysql.user table between to t