table content transfer from mysql to postgresql

brijesh

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

Nov 23 '05 #1

Subscribe Reply

1888

Bhavin Patel

br*****@divinet access.com (brijesh) wrote in message news:<7b******* *************** ****@posting.go ogle.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

Nov 23 '05 #2

Bhavin Patel

br*****@divinet access.com (brijesh) wrote in message news:<7b******* *************** ****@posting.go ogle.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

Nov 23 '05 #3

Bill Moran

br*****@divinet access.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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #4

Jason Sheets

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: pg************* ****@postgresql .org
[mailto:pg****** ***********@pos tgresql.org] On Behalf Of brijesh
Sent: Friday, June 04, 2004 1:28 AM
To: pg***********@p ostgresql.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 ma*******@postg resql.org so that your
message can get through to the mailing list cleanly
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 23 '05 #5

Bill Moran

br*****@divinet access.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

Nov 23 '05 #6

Jason Sheets

Nov 23 '05 #7

Similar topics

45232

how to import data into table

by: John Kolvereid | last post by:

How does one import data INTO a table. I am forced to read files (\i) w/ a ton of insert statements. I am trying to import approx 800 lines into the table. However, I must bundle them into a series of files because of the bug in PGSQL (the buffer overflows). Interestingly, the literature claims that the one feature of PostgreSQL is SPEED. HA! Reading a single file w/ all the same inserts into MySQL takes literally a fraction of a...

PostgreSQL Database

1544

i need help, innodb blocks insertion into table for a while

by: Bernhard Schmidt | last post by:

------=_NextPart_000_0030_01C34C51.B8F4D1A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi dear mysql list members =20 i have setup a mysql database 4.013 with innodb enabled. when i set the =

MySQL Database

1631

Using data in one table to update data in another table

by: Chris Nighswonger | last post by:

------=_NextPart_000_0013_01C352C0.6B0A6E30 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi All, Is it possible in MySQL to use UPDATE to update fields in one table = with data from another table? For example, the following code seems to be the answer but fails with a syntax error in MySQL:

MySQL Database

1126

table error 127

by: Jonathan Patton | last post by:

------_=_NextPart_001_01C35A98.861F1984 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have mysql setup on two computers with identical databases. When I run = a group of queries on the one computer I get back an error 127 which I = checked on an it appears to be a table corruption error. On the other = computer, the queries run fine. Since I had all the data for the table = in question in...

MySQL Database

1160

User table and version

by: Robert Morgan | last post by:

------=_NextPart_000_0009_01C35CBD.258E1A30 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi I am using mysql 3.23.54 that came bundled with RH9. When I do a show = databases there is no user table, I am working through the reference = manual for 4.0 is the reason there is no user table because of the = version? also I have tried updating to version 4.0 using the RPM = available from the...

MySQL Database

2754

Reading table structure and data from sql file.

by: Binay Agarwal | last post by:

------=_NextPart_000_0046_01C3612B.931DFD50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi everybody, I have backed(backup.sql) up one Mysql database which contains 10 = tables using mysqldump.

MySQL Database

3147

mysql server crashes - high context switch rate - large 'merge' table

by: Johannes B. Ullrich | last post by:

--=-WKgoK98ejo9BZyGYc3N/ Content-Type: text/plain Content-Transfer-Encoding: quoted-printable I am having problems with MySQL 4.0.12 on RedHat Advanced Server 2.1 using a dual Xeon with 8 GByte of RAM. I have a database collecting logs. Each day, a new table is created. In order to allow for queries across more than one day, I use 'MERGE'

MySQL Database

7408

uploading image to mysql table

by: John Smith | last post by:

I know that uploading an image to a database has been covered, oh, about 3 trillion times. However, I haven't found anything covering uploading to a MySQL database with .net. Please don't recommend storing the image to the filesystem and only keeping a pointer to that in the table. I want to dump the image to a table. My code dumps the data into the table, however, I get the following error when trying to view the image "the image ......

C# / C Sharp

4787

altering a table to set serial function

by: Prabu Subroto | last post by:

Dear my friends... I am using postgres 7.4 and SuSE 9.1. I want to use auto_increment as on MySQL. I look up the documentation on www.postgres.com and I found "serial" . But I don't know how to create auto_increment. here is my try:

PostgreSQL Database

9680

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9528

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10230

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10012

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7548

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6788

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4118

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3731

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2926

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General