[BlueOnyx:01369] Re: mysql dump and restore
greg.kuhnert at theanchoragesylvania.com
Fri Jun 5 17:31:40 PET 2009
Tony C. Loosle wrote:
> How can I restore mysql users from 3 servers?
> I have to bq servers and one bx server. I have exported all of the
> sites on all servers and want to put them onto one new bx server.
> Last time the raqbackup.sh wrote over the exisiting mysql users. Is
> there a way to avoid this?
Try something like...
mysql --password=mypass --batch --skip-column-names --execute="SHOW
DATABASES" | grep -v "mysql" | xargs mysqldump --password=mypass
--databases > dump.sql
This will export all databases, excluding the "mysql" database. You will
of course need to manually migrate the user details from your 3 servers.
More information about the Blueonyx