Re: Migrating from MySQL
Marc G. Fournier <scrappy@hub.org>
From: The Hermit Hacker <scrappy@hub.org>
To: Paul Fontenot <paul@code-slinger.com>
Cc: pgsql-novice@postgresql.org
Date: 2000-06-13T18:25:08Z
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 ...