[rt-users] Tool to migrate from RT3 on postgres to RT3 on mys ql

[Dan Anderson]

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)

Dan

-----Original Message-----
From: freebsd at coal.sentex.ca [mailto:freebsd at coal.sentex.ca]
Sent: Friday, August 15, 2003 1:52 PM
To: rt-users at 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 at 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 at 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