Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id E8E822E0056 for ; Thu, 17 Apr 2008 08:02:08 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 74484-09 for ; Thu, 17 Apr 2008 08:01:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from ptb-relay03.plus.net (ptb-relay03.plus.net [212.159.14.214]) by developer.postgresql.org (Postfix) with ESMTP id C04172E004A for ; Thu, 17 Apr 2008 08:01:54 -0300 (ADT) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by ptb-relay03.plus.net with esmtp (Exim) id 1JmRsG-0004NT-1h; Thu, 17 Apr 2008 12:01:52 +0100 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id CDF5027405A; Thu, 17 Apr 2008 12:01:51 +0100 (BST) Message-ID: <48072E20.5010607@archonet.com> Date: Thu, 17 Apr 2008 12:01:52 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.12 (X11/20080213) MIME-Version: 1.0 To: dipesh CC: pgsql-sql@postgresql.org Subject: Re: Error in restore the Database in Postgres References: <48072899.3080102@mobilefundas.com> In-Reply-To: <48072899.3080102@mobilefundas.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: ab0563e7229f6de36d46de9edf4504cc X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.587 tagged_above=0 required=5 tests=AWL=-1.647, DEAR_SOMETHING=2.234 X-Spam-Level: X-Archive-Number: 200804/114 X-Sequence-Number: 30653 dipesh wrote: > Dear Sir, > I have Mysql database backup file ( xyz.sql ). Now i want to restore > this ( xyz.sql ) file into Postgres Database. > I try following command to restore but Postgres gives me the Error. You have a mysql dump, which is designed to restore to a MySQL database. It will include mostly standard SQL and also all the specific MySQL differences. You'll need to convert it to produce something that PostgreSQL can understand. http://pgfoundry.org/search/?type_of_search=soft&words=mysql&Search=Search Perhaps one of these two projects: http://pgfoundry.org/projects/mysql2pgsql/ http://pgfoundry.org/projects/my2postgres/ -- Richard Huxton Archonet Ltd