[rt-users] Re: database migration

[Rick Ellis]

Hi David,

Our guys used SQL plus to do the import. They didn't seem to do anything
significant to alter the data prior to import, so I don't know if that
is significant or not as I'm no expert on Oracle. You might also want to
look at Oracle Migration Workbench (OMWB) which is supposed to do fancy
things with MySQL. I can ask them next time I'm in their Office.

My dump statement is run from a batch file and is:

/usr/local/mysql/bin/mysqldump --complete-insert --add-drop-table rt3 >
./dump/rt3dump`date '+%y%m%d%H%M'`.sql;

Missing commas sounds like the sql isn't properly formed.

Rik

On Wed, 2004-04-21 at 19:04, David Cecchino wrote:
> 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>
> >
> >
-- 
Rick Ellis <Richard.Ellis at Sun.COM>