Re: [tim@perdue.net: Re: mysql2pgsql tool] - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: [tim@perdue.net: Re: mysql2pgsql tool]
Date
Msg-id 200110121444.f9CEi3g19917@candle.pha.pa.us
Whole thread Raw
In response to [tim@perdue.net: Re: mysql2pgsql tool]  (Jason Spence <thalakan@technologist.com>)
List pgsql-bugs
Oops, sorry,  Thomas Lockhart has worked on the tool and perhaps he can
fix this.  However, I have been trying to find someone who will analyze
each version and add the missing features from one into the other so we
can have one better version rather than two.

Looking at the code, my2pg.pl  seems much more complete.  Not sure if
mysql2pgsql does anything that my2pg.pl doesn't already do.  Comments?

> Hi.
>
> Are you sure it's for me ?
> In the bugreport said about mysql2pgsql, however I'm the author of my2pg.pl.
> Both tools are distributed with Postgres source distribution.
> Please confirm that's really for me.
>
> Thanks.
> Max Rudensky.
>
> On Wed, 10 Oct 2001 15:45:22 -0400 (EDT)
> Bruce Momjian <pgman@candle.pha.pa.us> wrote:
>
>
> > I am CC'ing the author of the mysql conversion tool.
>
> >> I'm trying to find the right people to send this bug report to, and
> >> Tim says you're the people, so... see attached email, please.
> >>
> >> --
> >>  - Jason
> >>
> >> Politicians are the same all over.  They promise to build a bridge even
> >> where there is no river.
> >>         -- Nikita Khrushchev
>
> > -- Start of included mail From: Tim Perdue <tim@perdue.net>
>
> >> Date: Sat, 6 Oct 2001 08:33:55 -0500
> >> To: Jason Spence <thalakan@technologist.com>
> >> Subject: Re: mysql2pgsql tool
> >> Content-Disposition: inline
> >> User-Agent: Mutt/1.3.12i
> >> X-MIME-Autoconverted: from quoted-printable to 8bit by graendal.lightconsulting.com
> >>id f96DeB873702
> >> Content-Disposition: inline; filename=mutt-graendal-74937-10
>
> >> Thanks. I didn't create that tool - the postgres team did.
> >>
> >> Tim
> >>
> >>
> >> On Fri, Oct 05, 2001 at 09:27:32PM -0700, Jason Spence wrote:
> >> > Hi -
> >> >
> >> > I'm using your mysql2pgsql tool to migrate a database over to
> >> > PostgreSQL.  Works great, except I had to do one thing:
> >> >
> >> > cat old-database.sql92 | sed -e 's/ TYPE=MyISAM//' -e 's/^#/--/' -e
> >> > 's/UNIQUE KEY/UNIQUE/' > output1.sql
> >> >
> >> > That takes care of the comments, the new suffix appended to each
> >> > CREATE TABLE clause, and a grammar difference in key declaration.
> >> >
> >> > There's also a problem with the UNIQUE clauses where MySQL wants an
> >> > index name before the parenthesized list of columns and PostgreSQL
> >> > just wants the list of columns immediately.  I couldn't figure out how
> >> > to fix that in sed, but maybe you can.
> >> >
> >> > --
> >> >  - Jason
> >> >
> >> > "Well, if you can't believe what you read in a comic book, what *___can*
> >> > you believe?!"
> >> >         -- Bullwinkle J. Moose [Jay Ward]
> >>
> >> --
> >> Founder - PHPBuilder.com / Geocrawler.com / SourceForge
> >> Perdue, Inc.
> >> 515-554-9520
> > -- End of included mail.
>
> >>
> >> ---------------------------(end of broadcast)---------------------------
> >> TIP 4: Don't 'kill -9' the postmaster
>
> > --
> > Bruce Momjian                        |  http://candle.pha.pa.us
> > pgman@candle.pha.pa.us               |  (610) 853-3000
> > +  If your life is a hard drive,     |  830 Blythe Avenue
> > +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #480: problem with LIKE pattern matches involving % and \_
Next
From: Thomas Lockhart
Date:
Subject: Re: Bug #463: Make 'infinity' work with type 'date'