Обсуждение: 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