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.
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 |