473,889 Members | 1,801 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Mysql to Postgresql

On Thursday 12 February 2004 20:25, Prashanthi Muthyala wrote:
Hi Richard
Hi Prashanthi - nice to hear from you again. I've taken the liberty of cc-ing
the general list on this, since there may be others who can help here.
I am trying to migrate the database and its tables from mysql in my
windows machine to postgresql in my new red hat linux . I was following
your links which has converstions from msaccess,mysql to postgresql and in
the process I have downloaded pgadmin 11 and i got the wizard. It says to
connect to target server. now what is that I need to write in that target
server?

the field in the connect wizard are
1. server
2.port
3.username
4.password
I have mysql control center in which I have some databases which I want to
transfer to postgresql .

is this pgadmin2 wizard will connect to the mysql server? what port number
should I give and I have some usernames and passwords in the mysql
database. shall I type those username and password.
Good question - I can't say, since I don't have pgadmin2 here. However, I do
know that PostgreSQL listens on port 5432 and MySQL on 3306.
Tip 1: On a linux box, look in the /etc/services file, that lists what port
most programs run on
Tip 2: "lsof -i" will show you what ports are in use and by what program.

I'd say try the mysql port/username/password and if that doesn't work, try the
postgresql ones.
Kindly let me know I actually thought of installing postgresql in windows
also and once I get the tables migrated from mysql to postgresql in the
same machine.. then I will burn it to cd and then thought of copying them
to postgresql present in red hat linux which is in different machine.
A linux box will read a CD burnt on a Windows machine just fine. Dump the
mysql database on the Windows PC and copy the files off.
actually both these machines are connected to the same LAN. but I dont
know if there exists any way to direct dump the mysql tables in windows
machine to postgresql in linux machine..


if the pgadmin wizard doesn't work, I would probably do something like:
1. On the windows machine use "mysqldump -T ..." to dump the database to a set
of .sql and .txt files
2. Fix the .sql files so you can recreate the tables in PG, and create the
tables either using psql or cutting and pasting into pgadmin
3. Use the COPY command to import the tab-separated text files, or do it with
pgadmin.

Note that if you copy the .txt files over to the linux box, you'll want to use
the dos2unix command to change the line-endings first. If that program isn't
installed on your linux box, then you'll probably find it on
http://www.rpmfind.net/

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 22 '05 #1
1 3371
Richard Huxton wrote:
On Thursday 12 February 2004 20:25, Prashanthi Muthyala wrote:
Hi Richard

Hi Prashanthi - nice to hear from you again. I've taken the liberty of cc-ing
the general list on this, since there may be others who can help here.


Um - 12th Feb? Where has this been lurking, and why has it emerged now?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
3497
by: Marek Lewczuk | last post by:
Hello group, For everyone who thinks about moving from MySQL to PostgreSQL I have a realy bad news - It's not worth. Why, You may ask... A few days ago I have installed and tested PostgreSQL, becouse I realy need UTF-8 support and subselects. I thought that PostgreSQL will be as good as MySQL but also will give me that features, which aren't availble in MySQL. Well, after installation and moving my MySQL dbs into PostgreSQL I decided to...
29
2605
by: smorrey | last post by:
I've been thinking on this long and hard, and I can't seem to come up with an answer on it. Why is it almost always assumed the MySQL will be the server for nearly any PHP app? Why is it MySQL and not PostGRES or SQLite? At this point the only reason I can think of is that MySQL has a much more friendly name. But is that really it?
33
5614
by: Joshua D. Drake | last post by:
Hello, I think the below just about says it all: http://www.commandprompt.com/images/mammoth_versus_dolphin_500.jpg Sincerely, Joshua Drake
74
8090
by: John Wells | last post by:
Yes, I know you've seen the above subject before, so please be gentle with the flamethrowers. I'm preparing to enter a discussion with management at my company regarding going forward as either a MySql shop or a Postgresql shop. It's my opinion that we should be using PG, because of the full ACID support, and the license involved. A consultant my company hired before bringing me in is pushing hard for MySql, citing speed and community...
3
2277
by: Marek Lewczuk | last post by:
Hello, I have changed DB from MySQL to PostgreSQL. When I have run my application on PostgreSQL it was disaster - it was much slower than MySQL... I have tried to change PG configuration file etc.. no luck. After many long days of thinking what is wrong I have made several tests with "EXPLAIN" statement, and to my amusement there was many SeqScan - MySQL didn't show that things. I have made some changes in PG db structure (new indexes...
175
11579
by: Sai Hertz And Control Systems | last post by:
Dear all, Their was a huge rore about MySQL recently for something in java functions now theirs one more http://www.mysql.com/doc/en/News-5.0.x.html Does this concern anyone. What I think is PostgreSQL would have less USP's (Uniqe Selling Points
67
12583
by: Bob Powell | last post by:
To whom it may concern: I find the recent articles in various trade publications a little disturbing due to the lack of PostgrSQL mention. I continue to see articles about how IBM may be considering MYSQL for development an open_source web database. Why isn't PostgreSQL being considered or talked about by major industry giants? As a DBA I know that Postgres is far superior to MYSQL but if the industry directs it's energies towards...
11
9959
by: Mark Cubitt | last post by:
the reason I ask is I have always used postgres at home and work, but my new web host only has mysql :( I want to know what sort of differences I will have in regards to programming php/perl webpages using the database. I current use sequences in postgres and understand this will be different in mysql, so can you tell me what the difference will be and if there are any other differences I should look out for.
12
1834
by: howa | last post by:
any side effect for PHP? what do you think?
0
9966
marktang
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...
0
11199
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10791
jinu1996
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...
0
10442
tracyyun
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...
0
9610
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7997
isladogs
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...
0
7150
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();...
0
5830
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
3
3256
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.