| From: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
|---|---|
| To: | "(dot)ep" <erick(dot)papa(at)gmail(dot)com> |
| Cc: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Importing *huge* mysql database into pgsql |
| Date: | 2007-03-06 14:43:49 |
| Message-ID: | 1173192229.9058.18.camel@coppola.muc.ecircle.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2007-03-06 14:54:02 | Re: Importing *huge* mysql database into pgsql |
| Previous Message | Andy | 2007-03-06 14:41:26 | Re: Importing *huge* mysql database into pgsql |