Re: How to insert the values of .sql file (dump file) into postgresql 8.1

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: How to insert the values of .sql file (dump file) into postgresql 8.1
Date: 2008-12-16 08:47:11
Message-ID: 20081216084711.GE4557@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

In response to sai srujan :
> Hi....
> This is srujan and I am beginner of postgresql 8.1 and I have
> just stopped using mysql and i would like to use the dump (.sql file)
> created in it. I would like transfer the databases in my sql to postgresql 8.1.
> Please do reply. I am waiting for it.
> Thanks in Advance

You can try to import your dump with psql -f <your_file>, but maybe you
need to edit the file to change the syntax to postgresql-compatible.

You can also use some tools to convert from mysql to postgresql, read
the links below:

09:44 < pg_docbot_adz> http://sql-info.de/mysql/gotchas.html :: http://www.raditha.com/mysql/mysql2pgsql.php ::
http://www.in-nomine.org/~asmodai/mysql-to-pgsql.html :: http://pgfoundry.org/projects/mysql2pgsql/ ::
http://www.metatrontech.com/wpapers/mysql2postgresql.pdf
09:44 < pg_docbot_adz> http://www.data-conversions.net/products.php?prod_num=5&&dest=MENU&&ID=200 :: http://forums.mysql.com/read.php?25,93181,93181 ::
http://www.postgresql.org/docs/techdocs.83 :: http://www.scribd.com/doc/2575733/The-future-of-MySQL-The-Project
09:44 < pg_docbot_adz> http://pgfoundry.org/projects/mysqlcompat :: http://www.xaprb.com/blog/2007/05/31/why-is-null-doesnt-always-work-in-mysql/ ::
http://weblogs.asp.net/alex_papadimoulis/archive/2005/10/26/428527.aspx
09:44 < pg_docbot_adz> http://mike.kruckenberg.com/archives/2006/07/jim_starkey_int_1.html

Some of the links are appropriate for you, it is the output from the
irc-docbot about mysql.

HTH, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message KaiGai Kohei 2008-12-16 09:36:55 [BUG?] UPDATE with RETURNING tableoid
Previous Message Emmanuel Cecchet 2008-12-16 08:19:31 Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1