Re: Migrating from MySQL - Mailing list pgsql-novice

From The Hermit Hacker
Subject Re: Migrating from MySQL
Date
Msg-id Pine.BSF.4.21.0006131524000.10507-100000@thelab.hub.org
Whole thread Raw
In response to Migrating from MySQL  ("Paul Fontenot" <paul@code-slinger.com>)
List pgsql-novice
On Tue, 13 Jun 2000, Paul Fontenot wrote:

> Is this a simple matter of doing a mysqldump to a textfile and a copy into
> my new postgresql database?

nope, as MySQL has "features" that aren't compatible with other databases
... different ways of doing database structure, non-SQL compliant types,
etc ... each database server tends to have their own quirks, some more
then others ... you'll have to hand massage the mysqldump to fit
PostgreSQL, but, having done it before, it is doable ...



pgsql-novice by date:

Previous
From: "Paul Fontenot"
Date:
Subject: Migrating from MySQL
Next
From: "Paul Fontenot"
Date:
Subject: SHOW , DESCRIBE, oh what's it called...