[BlueOnyx:01323] Re: mysql import

[Matthew Komar]

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
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.blueonyx.it/pipermail/blueonyx/attachments/20090527/e98b1b44/attachment.html>