| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Baron Schwartz | Date: | March 16 2012 6:19pm |
| Subject: | Re: how to sync mysql.user table between to two mysql instances | ||
| View as plain text | |||
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