User-Agent: K-9 Mail for Android
In-Reply-To: <1385310068777-5780061.post@n5.nabble.com>
References: <1385308157986-5780055.post@n5.nabble.com>
 <52922468.1060100@gmail.com> <1385310068777-5780061.post@n5.nabble.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="----PSEFECSWB6M42US1ENBJI6S6V9A9CY"
Subject: Re: Importing MySql dumped db into pgadmin
From: Jan Lentfer <Jan.Lentfer@web.de>
Date: Sun, 24 Nov 2013 17:37:03 +0100
To: miks87 <michele.imperiali@hotmail.it>,pgsql-sql@postgresql.org
Message-ID: <5f0b8d5e-bd25-4c00-8645-7600254f9367@email.android.com>
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

------PSEFECSWB6M42US1ENBJI6S6V9A9CY
Content-Type: text/plain;
 charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi,

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

Regards

Jan


miks87 <michele.imperiali@hotmail.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-p=
gadmin-tp5780055p5780061.html
>Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
>
>
>--=20
>Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-sql

--=20
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesend=
et.
------PSEFECSWB6M42US1ENBJI6S6V9A9CY
Content-Type: text/html;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body>Hi,<br>
<br>
it won&#39;t work that way because mysql is just too different. You might=
 want to look at the latest version of pgloader.<br>
<br>
Regards<br>
<br>
Jan<br><br><div class=3D"gmail_quote"><br>
<br>
miks87 &lt;michele.imperiali@hotmail.it&gt; schrieb:<blockquote class=3D"=
gmail_quote" style=3D"margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid r=
gb(204, 204, 204); padding-left: 1ex;">
<pre class=3D"k9mail">Hi Adrian, thanks for your answer. I'm using the ex=
port wizard from within<br />phpmyadim and I'm exporting in SQL. Then I'm=
 simply trying to execute the<br />SQL code within pgAdmin but I get seve=
ral errors in the code: a few examples<br />are the use of "AUTO_INCREMEN=
T" or also check conditions on table attributes<br />(I get error on the =
clause ON). Also I get error when integer attributes are<br />specified w=
ith the notazion int(maxlength)...<br /><br /><br /><br />--<br />View th=
is message in context: <a href=3D"http://postgresql.1045698.n5.nabble.com=
/Importing-MySql-dumped-db-into-pgadmin-tp5780055p5780061.html">http://po=
stgresql.1045698.n5.nabble.com/Importing-MySql-dumped-db-into-pgadmin-tp5=
780055p5780061.html</a><br />Sent from the PostgreSQL - sql mailing list =
archive at <a href=3D"http://Nabble.com">Nabble.com</a>.<br /><br /></pre=
></blockquote></div><br>
-- <br>
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesend=
et.</body></html>
------PSEFECSWB6M42US1ENBJI6S6V9A9CY--