Postgres to MySQL

RT Users
1

I think I am trying to do too many things at the same time. I have an
existing rt2 instance on Postgres on one server, and I am attempting to move
it to another server running a clean install of rt3 on MySQL. I was able to
use the rt2-rt3 tool to export the tickets and info, but I am getting this
error on import:

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)

I am by no means a Perl guru, so any help would be appreciated. Thanks!

Dan

2

I’ve got a tool to do a postgres to mysql migration on rt3. I’ll mail it
out after dinner.
-jOn Thu, Aug 14, 2003 at 05:03:18PM -0600, Dan Anderson wrote:

I think I am trying to do too many things at the same time. I have an
existing rt2 instance on Postgres on one server, and I am attempting to move
it to another server running a clean install of rt3 on MySQL. I was able to
use the rt2-rt3 tool to export the tickets and info, but I am getting this
error on import:

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)

I am by no means a Perl guru, so any help would be appreciated. Thanks!

Dan

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

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

3

We currently have RT running on a Postgres database but we’re upgrading
to the latest version of RT and we want to switch to MySQL for various
reasons. Does anyone know how to convert the data from a Postgres
database to MySQL database? Google hath given me nothing.

Thanks,
Don Salensky
dsalensky@servervault.com

4

We currently have RT running on a Postgres database but we’re upgrading
to the latest version of RT and we want to switch to MySQL for various
reasons. Does anyone know how to convert the data from a Postgres
database to MySQL database? Google hath given me nothing.

Not to start an r-war, but I’m curious why? Do you mind expanding?

Cheers,
– jra
Jay R. Ashworth jra@baylink.com
Designer Baylink RFC 2100
Ashworth & Associates The Things I Think '87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274

  If you can read this... thank a system administrator.  Or two.  --me
5

No problem. One of the reasons is because RT seems “designed” for MySQL.
Also, MySQL seems a little easier to use and we don’t really need the
additional functionality of Postgres for RT. And, thinking to future
releases of RT, we want the upgrades to go as smoothly as possible.

Thanks,
Don Salensky
dsalensky@servervault.comFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Jay R.
Ashworth
Sent: Thursday, May 26, 2005 23:18 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Postgres to MySQL

We currently have RT running on a Postgres database but we’re
upgrading to the latest version of RT and we want to switch to MySQL
for various reasons. Does anyone know how to convert the data from a
Postgres database to MySQL database? Google hath given me nothing.

Not to start an r-war, but I’m curious why? Do you mind expanding?

Cheers,
– jra
Jay R. Ashworth
jra@baylink.com
Designer Baylink
RFC 2100
Ashworth & Associates The Things I Think
'87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727
647 1274

  If you can read this... thank a system administrator.  Or two.

–me _______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

6

So does anyone know how to do this or where I could start? I have a SQL dump of the Postgres database, but I’m fairly database-retarded and I don’t know where to being. Is there any documentation anywhere that would help me?

Danke schön,
Don
dsalensky@servervault.comFrom: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Salensky, Don
Sent: Friday, May 27, 2005 12:30 PM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Postgres to MySQL

No problem. One of the reasons is because RT seems “designed” for MySQL.
Also, MySQL seems a little easier to use and we don’t really need the additional functionality of Postgres for RT. And, thinking to future releases of RT, we want the upgrades to go as smoothly as possible.

Thanks,
Don Salensky
dsalensky@servervault.com

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Jay R.
Ashworth
Sent: Thursday, May 26, 2005 23:18 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Postgres to MySQL

We currently have RT running on a Postgres database but we’re
upgrading to the latest version of RT and we want to switch to MySQL
for various reasons. Does anyone know how to convert the data from a
Postgres database to MySQL database? Google hath given me nothing.

Not to start an r-war, but I’m curious why? Do you mind expanding?

Cheers,
– jra
Jay R. Ashworth
jra@baylink.com
Designer Baylink
RFC 2100
Ashworth & Associates The Things I Think
'87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727
647 1274

  If you can read this... thank a system administrator.  Or two.

–me _______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com _______________________________________________
The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

7

Salensky, Don wrote:

So does anyone know how to do this or where I could start? I have a SQL dump of the Postgres database, but I’m fairly database-retarded and I don’t know where to being. Is there any documentation anywhere that would help me?

This may work, but I don’t know:
http://download.bestpractical.com/pub/rt/contrib/3.0/Conversion/rt3-on-pg-to-mysql

Danke sch�n,
Don
dsalensky@servervault.com

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Salensky, Don
Sent: Friday, May 27, 2005 12:30 PM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Postgres to MySQL

No problem. One of the reasons is because RT seems “designed” for MySQL.
Also, MySQL seems a little easier to use and we don’t really need the additional functionality of Postgres for RT. And, thinking to future releases of RT, we want the upgrades to go as smoothly as possible.

Thanks,
Don Salensky
dsalensky@servervault.com

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Jay R.
Ashworth
Sent: Thursday, May 26, 2005 23:18 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Postgres to MySQL

We currently have RT running on a Postgres database but we’re
upgrading to the latest version of RT and we want to switch to MySQL
for various reasons. Does anyone know how to convert the data from a
Postgres database to MySQL database? Google hath given me nothing.

Not to start an r-war, but I’m curious why? Do you mind expanding?

Cheers,
– jra

Jay R. Ashworth
jra@baylink.com
Designer Baylink
RFC 2100
Ashworth & Associates The Things I Think
'87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727
647 1274

 If you can read this... thank a system administrator.  Or two.

–me _______________________________________________
The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com _______________________________________________
The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati

8

Thanks, I’ll give it a try.

Don
dsalensky@servervault.com-----Original Message-----
From: Drew Barnes [mailto:barnesaw@ucrwcu.rwc.uc.edu]
Sent: Wednesday, June 01, 2005 12:19 PM
To: Salensky, Don
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Postgres to MySQL

This may work, but I don’t know:
http://download.bestpractical.com/pub/rt/contrib/3.0/Conversion/rt3-on-p
g-to-mysql