Re: Importing MySql dumped db into pgadmin

From: Jan Lentfer <Jan(dot)Lentfer(at)web(dot)de>
To: miks87 <michele(dot)imperiali(at)hotmail(dot)it>,pgsql-sql(at)postgresql(dot)org
Subject: Re: Importing MySql dumped db into pgadmin
Date: 2013-11-24 16:37:03
Message-ID: 5f0b8d5e-bd25-4c00-8645-7600254f9367@email.android.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

it won't work that way because mysql is just too different. You might want to look at the latest version of pgloader.

Regards

Jan

miks87 <michele(dot)imperiali(at)hotmail(dot)it> schrieb:
>Hi Adrian, thanks for your answer. I'm using the export wizard from
>within
>phpmyadim and I'm exporting in SQL. Then I'm simply trying to execute
>the
>SQL code within pgAdmin but I get several errors in the code: a few
>examples
>are the use of "AUTO_INCREMENT" or also check conditions on table
>attributes
>(I get error on the clause ON). Also I get error when integer
>attributes are
>specified with the notazion int(maxlength)...
>
>
>
>--
>View this message in context:
>http://postgresql.1045698.n5.nabble.com/Importing-MySql-dumped-db-into-pgadmin-tp5780055p5780061.html
>Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
>
>
>--
>Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-sql

--
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2013-11-24 17:06:58 Re: Importing MySql dumped db into pgadmin
Previous Message miks87 2013-11-24 16:21:08 Re: Importing MySql dumped db into pgadmin