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 s

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

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 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

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

2007-03-06 Thread Laurent ROCHE
]> 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

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 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 t

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 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 doab