[tim@perdue.net: Re: mysql2pgsql tool]

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

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:

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