From: | Dirk Heinrichs <heini(at)chaos(dot)tng(dot)oche(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Importing table from mysql |
Date: | 2000-06-12 08:05:17 |
Message-ID: | 00061210073100.16281@linux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Rainer Mager | 2000-06-12 08:25:38 | query buffer max length of 16384 exceeded |
Previous Message | selkovjr | 2000-06-11 21:53:55 | Sending e-mail from a trigger |