Tool to migrate from RT3 on postgres to RT3 on mys ql

Since I have to upgrade to RT3 before I can use this, can I install RT3 on
my existing RT2 server without impacting the RT2 database that is in
production?

Dan-----Original Message-----
From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Friday, August 15, 2003 1:17 AM
To: rt-users@fsck.com
Subject: [rt-users] Tool to migrate from RT3 on postgres to RT3 on mysql

Is now available at http://fsck.com/pub/rt/contrib/3.0/Conversion/

It’s a small tool I built for a client who wanted to move from Pg to
Mysql with their existing RT3 database.

You should start with a full RT database on postgres and an RT3 database
on mysql that contains only the schema and not the database content.

-j

http://www.bestpractical.com/rt – Trouble Ticketing. Free.
rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Thus spake Dan Anderson (dan.anderson@kincaidtech.com) [15/08/03 14:56]:

Since I have to upgrade to RT3 before I can use this, can I install RT3 on
my existing RT2 server without impacting the RT2 database that is in
production?

If you’re going to move from RT2 to RT3, just use the rt2-to-dumpfile to
pull from postgresql, and dumpfile-to-rt3 to push to mysql. We did it, and
aside from problems with the version of the script, we had zero troubles
with the import.

I tried that, and got this when trying to import back into MySql:

Importing users
u.u.u.u.u.u.u.u.u.u.u.u.u.uuu.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.
u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.
Importing groups
ggrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrqqqqqqqqqqImporting tickets…t-1000
Byte order is not compatible at …/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_retrieve.al) line 323, at ./dumpfile-to-rt-3.0 line
489
[Thu Aug 14 23:05:53 2003] [crit]: Ticket files could not be loaded at (eval
1657) line 1.
(/usr/local/rt3/lib/RT.pm:242)

DanFrom: freebsd@coal.sentex.ca [mailto:freebsd@coal.sentex.ca]
Sent: Friday, August 15, 2003 1:52 PM
To: rt-users@lists.fsck.com
Subject: Re: [rt-users] Tool to migrate from RT3 on postgres to RT3 on
mys ql

Thus spake Dan Anderson (dan.anderson@kincaidtech.com) [15/08/03 14:56]:

Since I have to upgrade to RT3 before I can use this, can I install RT3 on
my existing RT2 server without impacting the RT2 database that is in
production?

If you’re going to move from RT2 to RT3, just use the rt2-to-dumpfile to
pull from postgresql, and dumpfile-to-rt3 to push to mysql. We did it, and
aside from problems with the version of the script, we had zero troubles
with the import.
rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Thus spake Dan Anderson (dan.anderson@kincaidtech.com) [15/08/03 16:04]:

I tried that, and got this when trying to import back into MySql:

Importing users
u.u.u.u.u.u.u.u.u.u.u.u.u.uuu.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.
u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.u.
Importing groups
ggrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrqqqqqqqqqqImporting tickets…t-1000
Byte order is not compatible at …/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_retrieve.al) line 323, at ./dumpfile-to-rt-3.0 line
489
[Thu Aug 14 23:05:53 2003] [crit]: Ticket files could not be loaded at (eval
1657) line 1.
(/usr/local/rt3/lib/RT.pm:242)

(Insert all the normal troubleshooting questions here that have probably
been asked by now: Which version are you using? Which OS? How many tickets
are you exporting? Does it always die on the same ticket? Are you using
the same version of -to-dumpfile as dumpfile-to-? etc. etc.)

Dunno, then. It’s happening on the import, so you’ll need to import to RT3
before you can use the db conversion tool.