Re: [GENERAL] Importing *huge* mysql database into pgsql

2007-03-08 Thread Harald Fuchs
In article [EMAIL PROTECTED], .ep [EMAIL PROTECTED] writes: Hello, I would like to convert a mysql database with 5 million records and growing, to a pgsql database. All the stuff I have come across on the net has things like mysqldump and psql -f, which sounds like I will be sitting forever

[GENERAL] Importing *huge* mysql database into pgsql

2007-03-06 Thread .ep
Hello, I would like to convert a mysql database with 5 million records and growing, to a pgsql database. All the stuff I have come across on the net has things like mysqldump and psql -f, which sounds like I will be sitting forever getting this to work. Is there anything else? Thanks.

Re: [GENERAL] Importing *huge* mysql database into pgsql

2007-03-06 Thread Webb Sprague
I would like to convert a mysql database with 5 million records and growing, to a pgsql database. All the stuff I have come across on the net has things like mysqldump and psql -f, which sounds like I will be sitting forever getting this to work. Have you tried it? 5 million rows seem doable.

Re: [GENERAL] Importing *huge* mysql database into pgsql

2007-03-06 Thread Csaba Nagy
I would like to convert a mysql database with 5 million records and growing, to a pgsql database. I wouldn't qualify 5 million as huge. We have here several 100 million sized tables, and I still think it's a medium sized DB... All the stuff I have come across on the net has things like

Re: [GENERAL] Importing *huge* mysql database into pgsql

2007-03-06 Thread Richard Huxton
.ep wrote: Hello, I would like to convert a mysql database with 5 million records and growing, to a pgsql database. And where's the huge database? All the stuff I have come across on the net has things like mysqldump and psql -f, which sounds like I will be sitting forever getting this to

Re: [GENERAL] Importing *huge* mysql database into pgsql

2007-03-06 Thread Andy
.ep wrote: Hello, I would like to convert a mysql database with 5 million records and growing, to a pgsql database. All the stuff I have come across on the net has things like mysqldump and psql -f, which sounds like I will be sitting forever getting this to work. Is there anything else?

Re : [GENERAL] Importing *huge* mysql database into pgsql

2007-03-06 Thread Laurent ROCHE
PROTECTED] Cc : pgsql-general@postgresql.org Envoyé le : Mardi, 6 Mars 2007, 15h54mn 02s Objet : Re: [GENERAL] Importing *huge* mysql database into pgsql .ep wrote: Hello, I would like to convert a mysql database with 5 million records and growing, to a pgsql database. And where's the huge database

Re: [GENERAL] Importing *huge* mysql database into pgsql

2007-03-06 Thread Chris Browne
.ep [EMAIL PROTECTED] writes: Hello, I would like to convert a mysql database with 5 million records and growing, to a pgsql database. All the stuff I have come across on the net has things like mysqldump and psql -f, which sounds like I will be sitting forever getting this to work. Is

Re: [GENERAL] Importing *huge* mysql database into pgsql

2007-03-06 Thread Raymond O'Donnell
On 06/03/2007 16:53, Chris Browne wrote: Where's the *huge* database? 5 million records is nothing; I'll run ...unless they're all biggish BLOBs. ;-P Ray. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland

Re: [GENERAL] Importing *huge* mysql database into pgsql

2007-03-06 Thread Chris
.ep wrote: Hello, I would like to convert a mysql database with 5 million records and growing, to a pgsql database. All the stuff I have come across on the net has things like mysqldump and psql -f, which sounds like I will be sitting forever getting this to work. If you can convert the