Skip site navigation (1) Skip section navigation (2)

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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Jason Spence <thalakan(at)technologist(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, fonin(at)yahoo(dot)com
Subject: Re: [tim@perdue.net: Re: mysql2pgsql tool]
Date: 2001-10-10 19:45:22
Message-ID: 200110101945.f9AJjMI11476@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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(at)perdue(dot)net>

> Date: Sat, 6 Oct 2001 08:33:55 -0500
> To: Jason Spence <thalakan(at)technologist(dot)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(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

Responses

pgsql-bugs by date

Next:From: Hiroshi InoueDate: 2001-10-10 23:13:00
Subject: Re: SQLPutData bug ?
Previous:From: Mika MantylaDate: 2001-10-10 11:46:42
Subject: Re: SQLPutData bug ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group