Re: Importing *huge* mysql database into pgsql - Mailing list pgsql-general

From Csaba Nagy
Subject Re: Importing *huge* mysql database into pgsql
Date
Msg-id 1173192229.9058.18.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Importing *huge* mysql database into pgsql  (".ep" <erick.papa@gmail.com>)
List pgsql-general
> 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
> "mysqldump" and "psql -f", which sounds like I will be sitting forever
> getting this to work.

Why do you think that would be running forever ? It should be fast
enough. Or you mean it's "forever" measured in development effort ? I
would say you should give it a go, it shouldn't be that bad...

Cheers,
Csaba.



pgsql-general by date:

Previous
From: Korin Richmond
Date:
Subject: Re: plpythonu and PYTHONPATH/sys.path
Next
From: Richard Huxton
Date:
Subject: Re: Importing *huge* mysql database into pgsql