[BlueOnyx:01326] Re: mysql import

[Matthew Komar]

There is a table called 'mysql' that contains the users.

At a minimum you will need to investigate that section of the .sql files.

Tony C. Loosle wrote:
> I was merging two old BQ servers to a new BX server.  Pretty sure the 
> mysql users and database names where different, so if it did drop a 
> table it would not exist and be no problem.  
>  
> What seemed to happen was that it dropped users on the current server, 
> but did not drop any tables or databases.
>  
> t
>
>
> > That is fine for a migration.
> >
> > What you want is more of a 'merge' it sounds like.
> >
> > If you look at the mysqldump.sql file, it is going to contain
> > strings like 'if table exists, drop table'.
> >
> > The idea is that it is going to replace whatever is on the dst
> > server with what was on the src.
> >
> > To do what you are trying to do, it's going to take a little manual
> > work.
> >
> > Tony C. Loosle wrote:
> >>
> >>
> >> I followed Nuonce's backup
> >> instructions:
> >>
> > mysql -uroot -ppassword <
> >> hostname.of.source.mysqldump.sql
> >>
> > t
> >
> >
> >> Tony C. Loosle
> >> wrote:
> >>> I tried
> >> to move several sites from a bq server to a bx server.
> >>
> >>> the sites
> >> went ok, but the sql is very messed up.
> >>
> >>> the
> >> import deleted all the users that were there before.
> >>
> >>> Is there
> >> a different way to import the mysql and not delete the
> >>
> >>> existing
> >> users?
> >>
> >>
> >> Hmmmm.... how
> >> did you import it?   It's possible to run a mysql import and
> >> overwrite everything, or just add to the existing.
> >>
> >> More
> >> information is needed for us to help.
> >>
> >> _______________________________________________ Blueonyx mailing
> >> list Blueonyx at blueonyx.it
> >> http://www.blueonyx.it/mailman/listinfo/blueonyx
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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/20090527/e4ab1839/attachment.html>