Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37570=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1Vkd9H-00018N-SI
 for pgsql-sql@arkaria.postgresql.org; Sun, 24 Nov 2013 17:07:08 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37570=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1Vkd9H-00079Z-5B
 for pgsql-sql@arkaria.postgresql.org; Sun, 24 Nov 2013 17:07:07 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <adrian.klaver@gmail.com>) id 1Vkd9G-00078n-4k
 for pgsql-sql@postgresql.org; Sun, 24 Nov 2013 17:07:06 +0000
Received: from mail-pb0-x22e.google.com ([2607:f8b0:400e:c01::22e])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <adrian.klaver@gmail.com>) id 1Vkd9B-00059w-K8
 for pgsql-sql@postgresql.org; Sun, 24 Nov 2013 17:07:05 +0000
Received: by mail-pb0-f46.google.com with SMTP id md12so4155184pbc.33
 for <pgsql-sql@postgresql.org>; Sun, 24 Nov 2013 09:07:00 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=message-id:date:from:user-agent:mime-version:to:subject:references
 :in-reply-to:content-type:content-transfer-encoding;
 bh=EtIwybDRoo+Ocrbxhhzh+iJ2DZOg6NZWpxk3F3S4Lfk=;
 b=L0VUQrcFjQoKgdWe4JDiaxJPB6peDufu05zTKQks3htF5733a3ZErdPJ/pWtBAD91a
 W9+ESPAtzMCY/bAsS/Sdvvcncm5b/Ow4rDJwDsjciXvWCsxuMo08I7aZWOS6UqMYC0ei
 +xBX3SpgKpB1lr0SxNa/BwdYbFRsBn7Q8jYSvKEYZZFKbkGvadnLK5I9wEqYYTsQnc66
 0n2LFWpsU7pTc0AqXfT6qri3ZASZk/Hd8IJntrztxd/sW5B0o/NV3ZvdiMYu+hmcBAvQ
 yfw0IFkEUNBViNg6IFRjwLUKOTu9X5qQctFA0IxruRm2HOhZlsNejdMocYD6Q+1W8SXS
 1Onw==
X-Received: by 10.68.143.231 with SMTP id sh7mr8038073pbb.35.1385312820082;
 Sun, 24 Nov 2013 09:07:00 -0800 (PST)
Received: from panda.site (174-21-163-123.tukw.qwest.net. [174.21.163.123])
 by mx.google.com with ESMTPSA id hz10sm67437646pbc.36.2013.11.24.09.06.58
 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Sun, 24 Nov 2013 09:06:59 -0800 (PST)
Message-ID: <52923232.4030008@gmail.com>
Date: Sun, 24 Nov 2013 09:06:58 -0800
From: Adrian Klaver <adrian.klaver@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
 rv:24.0) Gecko/20100101 Thunderbird/24.1.1
MIME-Version: 1.0
To: miks87 <michele.imperiali@hotmail.it>, pgsql-sql@postgresql.org
Subject: Re: Importing MySql dumped db into pgadmin
References: <1385308157986-5780055.post@n5.nabble.com>
 <52922468.1060100@gmail.com> <1385310068777-5780061.post@n5.nabble.com>
In-Reply-To: <1385310068777-5780061.post@n5.nabble.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -0.9 (/)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 11/24/2013 08:21 AM, miks87 wrote:
> 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)...

Yea, as previously noted that will not work.

Some docs:

https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL

Per the pgloader suggestion take a look at this blog from the author:

http://tapoueh.org/blog/2013/11/12-migrating-sakila

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


-- 
Adrian Klaver
adrian.klaver@gmail.com


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql