[BlueOnyx:19349] Re: CMU Import - append

Colin Jack colin at mainline.co.uk
Thu Mar 17 13:04:29 -05 2016


Hi Michael,

 > The best way I found to merge these is the "pt-show-grants" command
> > from Percona Toolkit. See:
> >
> > https://www.percona.com/doc/percona-toolkit/2.0/pt-show-grants.html
> >
> > ./pt-show-grants <mysql-password> > MySQLUserGrants.sql
> >
> > If you install the toolkit on the source server and run the above
> > command, it'll dump you an SQL file with all MySQL users and their privileges.
> >

Struggling to install percona-toolkit. 5106R :(

Will have another go later. I keep getting a GPG key error.
Installed the key etc.
Even tried installing from the percona repo.

I'm obviously missing something.

Thanks

Colin




More information about the Blueonyx mailing list