[BlueOnyx:01328] Re: mysql import

Michael Stauber mstauber at blueonyx.it
Thu May 28 05:24:56 -05 2009


Hi Darrell,

> Could this be a result of BX's name schema for new MySQL databases,
> something that didn't exist under BQ?

No, he tried to merge MySQL data from two different BQ servers into one BX 
box. For Databases that's fine, but the 2nd MySQL-Import (done from the 
command line) dropped the MySQL usertable from the first MySQL import.

Merging MySQL user databases is tricky regardless of platform. If you really 
want to do that, then the standard NuOnce reciepe for migrations won't do. For 
the 2nd MySQL import you need to have a dump of the "mysql" table without the 
"drop" command in it *and* you need to manualy edit out all user names that 
are already present.

-- 
With best regards

Michael Stauber




More information about the Blueonyx mailing list