Skip site navigation (1) Skip section navigation (2)

Re: Error in restore the Database in Postgres

From: Richard Huxton <dev(at)archonet(dot)com>
To: dipesh <dipesh(dot)mistry(at)mobilefundas(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Error in restore the Database in Postgres
Date: 2008-04-17 11:01:52
Message-ID: 48072E20.5010607@archonet.com (view raw or flat)
Thread:
Lists: pgsql-sql
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

In response to

pgsql-sql by date

Next:From: Marcin KrawczykDate: 2008-04-18 09:44:12
Subject: triggers order
Previous:From: Craig RingerDate: 2008-04-17 10:51:12
Subject: Re: error codes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group