By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,834 Members | 2,240 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,834 IT Pros & Developers. It's quick & easy.

MySQL-to-PostgreSQL

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

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 | (610) 359-1001
+ 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

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
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

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.