Postgres Pro
Downloads
Home   >   mailing lists

Thread: MySQL-to-PostgreSQL

MySQL-to-PostgreSQL

From
Yevgeny Ioffe
Date:
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!

Re: MySQL-to-PostgreSQL

From
Bruce Momjian
Date:
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
  pgman@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

Re: MySQL-to-PostgreSQL

From
Martin Marques
Date:
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                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

Re: MySQL-to-PostgreSQL

From
"Marek Lewczuk"
Date:
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: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Yevgeny Ioffe
> Sent: Thursday, September 25, 2003 9:20 PM
> To: pgsql-general@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