472,356 Members | 1,751 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,356 software developers and data experts.

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

the field in the connect wizard are
1. server
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

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

Richard Huxton
Archonet Ltd

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

Nov 22 '05 #1
1 3221
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

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,...
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...
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
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...
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...
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...
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...
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...
by: howa | last post by:
any side effect for PHP? what do you think?
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. header("Location:".$urlback); Is this the right layout the...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...

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.