[rt-users] Re: database migration

[David Cecchino]

Real quick question, which mysqldump flags were your giving to dump your
database , and then import to oracle sql?

it seems to be having some problems on attachmentswhere is missing
commas.



dave


On Wed, 21 Apr 2004, Rick Ellis wrote:

> David,
>
> That is MySQl 4.0.18-max, but it shouldn't matter. Both produce valid
> sql in the dump file.
>
> Rik
>
> On Wed, 2004-04-21 at 12:44, David Cecchino wrote:
> > Rick Does that also work for mysql version 4 , or are you running 3x
> > version?
> >
> > -dave
> >
> >
> >
> > On Wed, 21 Apr 2004, Rick Ellis wrote:
> >
> > > Hi David,
> > >
> > > I have spoken to two of our Oracle DBA's this morning and they tell me
> > > that Oracle can handle Mysqldump files perfectly well.
> > >
> > > To prove a point, they used my backup dump files to create an Oracle
> > > instance on our dev server.
> > >
> > > So long as the sql you output is valid, "Oracle doesn't care". They said
> > > try sql plus or sequencer.
> > >
> > > Rik
> > >
> > >
> > > > Message: 2
> > > > Date: Tue, 20 Apr 2004 16:27:07 -0400 (EDT)
> > > > From: David Cecchino <cecchind at qwestip.net>
> > > > Subject: Re: [rt-users] database migration
> > > > To: Les Mikesell <les at futuresource.com>
> > > > Cc: rt-users at lists.bestpractical.com
> > > > Message-ID: <Pine.GSO.4.58L0.0404201626500.7620 at qmail>
> > > > Content-Type: TEXT/PLAIN; charset=US-ASCII
> > > >
> > > > thats just for mysql to mysql, i need mysql -> oracle , thanks for the
> > > > reply.
> > > >
> > > > dave
> > > >
> > > >
> > > >
> > > > On Tue, 20 Apr 2004, Les Mikesell wrote:
> > > >
> > > > > On Tue, 2004-04-20 at 09:08, David Cecchino wrote:
> > > > >
> > > > > > Had a quick question I have a webrt system running 3.0.9 with mysql, I
> > > > > > have a dev box running webrt 3.0.10 with oracle 9i. I have the mysql
> > > > > > dumped , just need a nice way of importing the data, I was wondering if
> > > > > > anyone out there has a way or maybe can share some information.
> > > > >
> > > > > "man mysqldump" for details.  It suggests:
> > > > >
> > > > > mysqldump --opt database | mysql --host=remote-host -C database
> > > > > as one way to move a database - or redirect to a file on the
> > > > > dump and from the file on the restore.
> > > > >
> > > > > ---
> > > > >   Les Mikesell
> > > > >     les at futuresource.com
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > >
> > > --
> > > Rick Ellis <Richard.Ellis at Sun.COM>
> > >
> > > _______________________________________________
> > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> > >
> > > RT Developer and Administrator training is coming to LA, DC and Frankfurt this spring and summer.
> > > http://bestpractical.com/services/training.html
> > >
> > > Sign up early, as class space is limited.
> > >
> --
> Rick Ellis <Richard.Ellis at Sun.COM>
>
>