Re: mysql 2 pg script... - Mailing list pgsql-general

From Andy Colson
Subject Re: mysql 2 pg script...
Date
Msg-id 4D5FCA62.1020204@squeakycode.net
Whole thread Raw
In response to mysql 2 pg script...  (andrew1 <andrew1@mytrashmail.com>)
List pgsql-general
On 02/18/2011 08:03 PM, andrew1 wrote:
> hi all, I need to load mysql dump to postgre 8.3 . Is there a script to do that? I hoped to use my2pg.pl , but
couldn'tfind it. 
> It looks like it's not a part of /contrib in debian lenny.
> what shoud I use for 8.3?
>
> thanks.
>

I cannot convert the dump, but if you still have access to the mysql server I have a perl script that'll connect to it
anddump into a PG compatible format.  It wont generate create table statements, you'll have to do that yourself. 

I'll post it if you are interested.

-Andy

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: PostgreSQL For Beginners
Next
From: Raymond O'Donnell
Date:
Subject: Re: Schema Archive cant find table