[BlueOnyx:01333] Re: mysql import

[Matthew Komar]

That'd do it.

Tony C. Loosle wrote:
> Here is what I had or did:
>  
> I setup a BX server, had a few users, sites and sql database's on it.
>  
> Then I imported a BQ server, all seemed ok, then the 2nd BQ and it 
> lost the original users on the BX.
>  
> So, Michael, I need to edit the mysqldump before importing it? 
>  Removing the "drop" command and check for duplicate users?
>  
> thanks
>  
> t
>
>
> > 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.
> ------------------------------------------------------------------------
>
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at blueonyx.it
> http://www.blueonyx.it/mailman/listinfo/blueonyx
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.blueonyx.it/pipermail/blueonyx/attachments/20090528/7302dabf/attachment.html>