Re: Migrating from MySQL

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Paul Fontenot <paul(at)code-slinger(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Migrating from MySQL
Date: 2000-06-13 18:25:08
Message-ID: Pine.BSF.4.21.0006131524000.10507-100000@thelab.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ...

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Paul Fontenot 2000-06-13 23:22:16 SHOW , DESCRIBE, oh what's it called...
Previous Message Paul Fontenot 2000-06-13 16:44:27 Migrating from MySQL