Re: Importing table from mysql

Поиск
Список
Период
Сортировка
От Dirk Heinrichs
Тема Re: Importing table from mysql
Дата
Msg-id 00061210073100.16281@linux
обсуждение исходный текст
Ответ на Re: Importing table from mysql  ("Anthony E. Greene" <agreene@pobox.com>)
Список pgsql-admin
On Fre, 02 Jun 2000, Anthony E. Greene wrote:
>At 11:17 2000-06-02 +0530, Pragati Sagar wrote:
>>I already have  a database created in mysql. But now I want to shift from
>>mysql to postgresql but my problem is how to convert mysql database to
>>postgresql. How will I import the tables from mysql? Please help me with
>>this as I have not been able to find any diocumentaion on the net.
>
>Does mysql have a command analogous to pg_dump? If you could get all the
>data out and include the SQL commands it takes to recreate the database,
>that would be best.
>
>Alternatively, you export the data into tab or comma-delimited text files
>and use the \copy command in psql to import it into existing tables.

You could also write a perl script, that fetches the data from the mysql db
and inserts it into the psql db using DBI.

Bye...

    Dirk

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

Предыдущее
От: selkovjr@mcs.anl.gov
Дата:
Сообщение: Sending e-mail from a trigger
Следующее
От: Michael Ansley
Дата:
Сообщение: RE: query buffer max length of 16384 exceeded