List:General Discussion« Previous MessageNext Message »
From:David Lerer Date:March 16 2012 7:09pm
Subject:RE: how to sync mysql.user table between to two mysql instances
View as plain text  
I was trying to get a confirmation too. 
In any event, Charles, I'd try these three steps below and see what happens. I assume that
information_schema is populated "on the fly".
David.

-----Original Message-----
From: Brown, Charles [mailto:CBrown@stripped] 
Sent: Friday, March 16, 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 inst2. I would like to sync these
tables. How do you do it in short of creating 26 accounts in mysqlinst2 one at a time -
too tedious. Help me I'm running out of time.



-----Original Message-----
From: David Lerer [mailto:DLerer@stripped] 
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, will it be ok to do the following:

1. mysqldump -hmysql-inst2 mysql
2. Backup mysql-inst1 and use the backup to restore to mysql-inst2 
3. mysql -hmysql-inst2 mysql

This way I hope to be able to refresh a DEV instance from a PROD database, but preserve
the permissions, users, passwords, etc (Assuming of course that the schemas are identical
on the two instances).

Thanks, David.

-----Original Message-----
From: baron.schwartz@stripped [mailto:baron.schwartz@stripped] On Behalf Of Baron
Schwartz
Sent: Friday, March 16, 2012 2:20 PM
To: MySql
Subject: Re: how 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 <CBrown@stripped> wrote:
> 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: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql


The information contained in this e-mail and any attached 
documents may be privileged, confidential and protected from 
disclosure.  If you are not the intended recipient you may not 
read, copy, distribute or use this information.  If you have 
received this communication in error, please notify the sender 
immediately by replying to this message and then delete it 
from your system.

-- 
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.
********************************************

The information contained in this e-mail and any attached 
documents may be privileged, confidential and protected from 
disclosure.  If you are not the intended recipient you may not 
read, copy, distribute or use this information.  If you have 
received this communication in error, please notify the sender 
immediately by replying to this message and then delete it 
from your system.
Thread
Can't connect as non-root user to databaseClemens Eisserer16 Mar
  • Re: Can't connect as non-root user to databaseClaudio Nanni16 Mar
Re: Can't connect as non-root user to databaseClemens Eisserer16 Mar
  • Re: Can't connect as non-root user to databaseRik Wasmus16 Mar
    • Re: Can't connect as non-root user to databaseClemens Eisserer16 Mar
      • Re: Can't connect as non-root user to databaseClaudio Nanni16 Mar
        • Re: Can't connect as non-root user to databaseClaudio Nanni16 Mar
        • Re: Can't connect as non-root user to databaseClemens Eisserer16 Mar
          • Re: Can't connect as non-root user to databaseClaudio Nanni16 Mar
      • Re: Can't connect as non-root user to databaseRik Wasmus16 Mar
      • Re: Can't connect as non-root user to databaseshawn green16 Mar
        • how to sync mysql.user table between to two mysql instancesCharles Brown16 Mar
          • Re: how to sync mysql.user table between to two mysql instancesBaron Schwartz16 Mar
            • RE: how to sync mysql.user table between to two mysql instancesDavid Lerer16 Mar
              • RE: how to sync mysql.user table between to two mysql instancesCharles Brown16 Mar
                • RE: how to sync mysql.user table between to two mysql instancesDavid Lerer16 Mar
            • Re: how to sync mysql.user table between to two mysql instancesJohan De Meersman16 Mar
              • RE: how to sync mysql.user table between to two mysql instancesCharles Brown17 Mar
        • Re: Can't connect as non-root user to databaseClemens Eisserer16 Mar
          • Re: Can't connect as non-root user to databaseshawn green16 Mar