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.
