Re: Importing *huge* mysql database into pgsql

Поиск
Список
Период
Сортировка
От Csaba Nagy
Тема Re: Importing *huge* mysql database into pgsql
Дата
Msg-id 1173192229.9058.18.camel@coppola.muc.ecircle.de
обсуждение исходный текст
Ответ на Importing *huge* mysql database into pgsql  (".ep" <erick.papa@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Korin Richmond
Дата:
Сообщение: Re: plpythonu and PYTHONPATH/sys.path
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Importing *huge* mysql database into pgsql