[rt-users] Re: database migration

Rick Ellis Richard.Ellis at Sun.COM
Wed Apr 21 08:08:22 EDT 2004


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>




More information about the rt-users mailing list