Re: Mysql to Postgresql

Поиск
Список
Период
Сортировка
От Jaime Crespo Rincón
Тема Re: Mysql to Postgresql
Дата
Msg-id AANLkTi=vtfn+C16YHErcOV9yR_BCaoC1TdM9666TTsPZ@mail.gmail.com
обсуждение исходный текст
Ответ на Mysql to Postgresql  (Adarsh Sharma <adarsh.sharma@orkash.com>)
Ответы Re: Mysql to Postgresql
Список pgsql-general
Дерево обсуждения 
2011/2/22 Adarsh Sharma <adarsh.sharma@orkash.com>:
> Dear all,
>
> Today I need to back up a mysql database and restore in Postgresql database
> but I don't know how to achieve this accurately.

Have a look at: "mysqldump --compatible=postgresql" command:
<http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_compatible>

Anyway, most of the times you will need a more manual migration, with
human intervention (custom scripts) and migrating the data through
something like CSV (SELECT... INTO OUTFILE).


--
Jaime Crespo
MySQL & Java Instructor
Software Developer
Warp Networks
<http://warp.es>

В списке pgsql-general по дате отправления: