From: Scott Marlowe <scott.marlowe@gmail.com>
To: Gerd König <koenig@transporeon.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: move from mysql to postgresql
Date: Wed, 19 Nov 2008 09:25:15 -0700
Message-ID: <dcc563d10811190825v5c139131u8f41f6ea6db776ae@mail.gmail.com> (raw)
In-Reply-To: <492148D7.80207@transporeon.com>
References: <492148D7.80207@transporeon.com>
On Mon, Nov 17, 2008 at 3:35 AM, Gerd König <koenig@transporeon.com> wrote:
> Hello,
>
> we're going to switch from mysql (ver. 5.0.26) to PostgreSQL (OS:
> opensuse 10.3).
> The mysql database includes several instances, and we only want to
> migrate the bugzilla instance to Postgres (yes, it's the bugzilla
> backend...).
> What are the preferred steps to perform this migration ? ("cost free"
> solutions are highly appreciated ;-) ).
The general method is to dump the schema and data separately, then
hand mangle the schema as necessary to make it work in pgsql and then
import the data, with whatever mangling needed there to fix the
inevitably messed up data, like dates of 0000-00-00 which make no
sense whatsoever.
However, since bugzilla supports pgsql directly, I'd imagine you can
use the bugzilla population scripts to create your schema in pgsql and
then you only have to massage the data dump from mysql-bugzilla to
make it work.
If you are familiar with sed, it's awefull useful for fixing up broken
data. Or you can toss together a script in one of the P or R
languages (Perl, PHP, Python, Ruby et. al.) to fix it up. Usually
it's pretty easy, but if you get stumped on some part post back with
questions and somebody should jump on it.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, koenig@transporeon.com
Subject: Re: move from mysql to postgresql
In-Reply-To: <dcc563d10811190825v5c139131u8f41f6ea6db776ae@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox