pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedmove from mysql to postgresql
2+ messages / 2 participants
[nested] [flat]
* move from mysql to postgresql
@ 2008-11-17 10:35 Gerd König <koenig@transporeon.com>
0 siblings, 1 reply; 2+ messages in thread
From: Gerd König @ 2008-11-17 10:35 UTC (permalink / raw)
To: pgsql-admin
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 ;-) ).
thanks in advance ...GERD...
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: move from mysql to postgresql
@ 2008-11-19 16:25 Scott Marlowe <scott.marlowe@gmail.com>
parent: Gerd König <koenig@transporeon.com>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2008-11-19 16:25 UTC (permalink / raw)
To: Gerd König <koenig@transporeon.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-11-19 16:25 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-11-17 10:35 move from mysql to postgresql Gerd König <koenig@transporeon.com>
2008-11-19 16:25 ` Scott Marlowe <scott.marlowe@gmail.com>
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