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
one 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 ar
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
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
