| From: | Andy Colson <andy(at)squeakycode(dot)net> |
|---|---|
| To: | andrew1 <andrew1(at)mytrashmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: mysql 2 pg script... |
| Date: | 2011-02-19 13:49:22 |
| Message-ID: | 4D5FCA62.1020204@squeakycode.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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't find 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 and dump 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2011-02-19 14:03:29 | Re: Schema Archive cant find table |
| Previous Message | PANAGIOTIS GERMANIS | 2011-02-19 11:46:10 | Mac OSX 10.6 libpq.5.dylib |