[BlueOnyx:01327] Re: mysql import

[Darrell D. Mobley]

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

> -----Original Message-----
> From: blueonyx-bounces at blueonyx.it [mailto:blueonyx-bounces at blueonyx.it]
> On Behalf Of Tony C. Loosle
> Sent: Wednesday, May 27, 2009 3:33 PM
> To: BlueOnyx General Mailing List
> Subject: [BlueOnyx:01325] Re: mysql import
> 
> 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