MySQL-to-PostgreSQL

[Yevgeny Ioffe]

Hello,

I am working on transferring MySQL dumps to
PostgreSQL. I have tried the scripts I found in
relevant section of PostgreSQL documentation website,
but they all give me various parsing errors. What am
I to do?

Thanks!

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Bruce Momjian]

Have you tried src/contrib/mysql scripts?

---------------------------------------------------------------------------

Yevgeny Ioffe wrote:

Hello,

I am working on transferring MySQL dumps to
PostgreSQL. I have tried the scripts I found in
relevant section of PostgreSQL documentation website,
but they all give me various parsing errors. What am
I to do?

Thanks!

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.pha.pa.us | [phone]
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Martin Marques]

This scripts don't do the job completly, but give you a boost. I normally pass
my MySQL dumps throught these scripts and then open them with my editor and
do the changes that were missing.

You will always have to make changes in things like MySQLs inconsistencys
(dates that don't exist, an so on).

El Jue 25 Sep 2003 19:49, Bruce Momjian escribió:

Have you tried src/contrib/mysql scripts?

---------------------------------------------------------------------------

Yevgeny Ioffe wrote:

Hello,

I am working on transferring MySQL dumps to
PostgreSQL. I have tried the scripts I found in
relevant section of PostgreSQL documentation website,
but they all give me various parsing errors. What am
I to do?

Thanks!

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués | mm******@unl.edu.ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[Marek Lewczuk]

I suggest you to do it manualy.... I'm mean the structure only... Then
you can make mysqldump only with inserts... Belive me that this is much
faster....

-----Original Message-----
From: pg*****************@postgresql.org
[mailto:pg*****************@postgresql.org] On Behalf Of Yevgeny Ioffe
Sent: Thursday, September 25, 2003 9:20 PM
To: pg***********@postgresql.org
Subject: [GENERAL] MySQL-to-PostgreSQL
Hello,

I am working on transferring MySQL dumps to
PostgreSQL. I have tried the scripts I found in
relevant section of PostgreSQL documentation website,
but they all give me various parsing errors. What am
I to do?

Thanks!

---------------------------(end of
broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings