Thread: table content transfer from mysql to postgresql

Sir,
I am a development engineer in network application
I have a problem regarding upgrading my database
the problem is how do I transfer the contents from one table in a
database from one server to postgresql database table in another
server.
the data contents is in few MB.
can you suggest me an easy way to do so?
regards
Brijesh Shetty

brijesh@divinetaccess.com (brijesh) wrote:

> Sir,
> I am a development engineer in network application
> I have a problem regarding upgrading my database
> the problem is how do I transfer the contents from one table in a
> database from one server to postgresql database table in another
> server.
> the data contents is in few MB.
> can you suggest me an easy way to do so?
> regards
> Brijesh Shetty

You could write a script in any number of languages that supports both
Postgres and MySQL, perl and PHP come to mind, although I'm sure there are
far more than those two.

You could also use the mysqldump program with the proper switches to produce
SQL standards-compliant SQL insert statements and then pipe the resultant
SQL script into Postgres.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com

Tools already exist to convert a MySQL dump to a PostgreSQL format in
contrib/mysql.

You may wish to do some hand tuning before importing the converted dump into
PostgreSQL.

Jason

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of brijesh
Sent: Friday, June 04, 2004 1:28 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] table content transfer from mysql to postgresql

Sir,
I am a development engineer in network application I have a problem
regarding upgrading my database the problem is how do I transfer the
contents from one table in a database from one server to postgresql database
table in another server.
the data contents is in few MB.
can you suggest me an easy way to do so?
regards
Brijesh Shetty

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly

brijesh@divinetaccess.com (brijesh) wrote in message news:<7bccde45.0406032328.2ba7b934@posting.google.com>...
> Sir,
> I am a development engineer in network application
> I have a problem regarding upgrading my database
> the problem is how do I transfer the contents from one table in a
> database from one server to postgresql database table in another
> server.
> the data contents is in few MB.
> can you suggest me an easy way to do so?
> regards
> Brijesh Shetty

use phpmyadmin
export your data in sql format

run that sql script in postgresql through phppgadmin or pgadmin

Bhavin Patel