RT 3.x migration to new server

I am in the process of setting up a new RT server. I have the server up
and running RT. Now I need to migrate the data. I have found information
on migrating from RT2 to RT3 but nothing on server - to - server. I am
assuming that DB dump is all that is needed. Is this correct?

Old System
RT 3.0.6
Redhat 8
Apache 2.0.40
MySQL 4.0.15

New System
RT 3.2.2
Fedora Core 2
Apache 2.0.51
MySQL 4.0.22

Most anything is after you’ve done it successfully a few times

Leon
Network and Systems Administrator

I would suggest installing RT3.2.2 on the old system and do the upgrade.
Then you can just do a mysql dump to the new system. You will have the
new system nice and clean :slight_smile: without any old RT and/or no-longer-needed
perl modules.

As far as I remember, there are differences in DB schema between 3.0.6
and 3.2.2, so you cannot do the dump itself.

I’ve done migration from RT 2.0.X, mysql 3 and perl 5.8.0 to RT3.2,
mysql 4 perl 5.8.3 and it worked.

MichaelOn Wed, 2004-12-08 at 14:28, Leon wrote:

I am in the process of setting up a new RT server. I have the server up
and running RT. Now I need to migrate the data. I have found information
on migrating from RT2 to RT3 but nothing on server - to - server. I am
assuming that DB dump is all that is needed. Is this correct?

Old System
RT 3.0.6
Redhat 8
Apache 2.0.40
MySQL 4.0.15

New System
RT 3.2.2
Fedora Core 2
Apache 2.0.51
MySQL 4.0.22

Most anything is after you’ve done it successfully a few times

Leon
Network and Systems Administrator


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

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

I would suggest installing RT3.2.2 on the old system and do the
upgrade.
Then you can just do a mysql dump to the new system. You will have the
new system nice and clean :slight_smile: without any old RT and/or no-longer-needed
perl modules.

As far as I remember, there are differences in DB schema between 3.0.6
and 3.2.2, so you cannot do the dump itself.

well, why not just copy the DB to the new server, and then pretend the
new 3.2.2 install is really an upgrade? you get the same result with
fewer steps.

Between 3.0 and 3.2 you just have to apply some DB schema changes. no
dump/reload crap necessary.

Vivek Khera, Ph.D.
+1-301-869-4449 x806

I would suggest installing RT3.2.2 on the old system and do the
upgrade.
Then you can just do a mysql dump to the new system. You will have the
new system nice and clean :slight_smile: without any old RT and/or no-longer-needed
perl modules.

As far as I remember, there are differences in DB schema between 3.0.6
and 3.2.2, so you cannot do the dump itself.

well, why not just copy the DB to the new server, and then pretend the
new 3.2.2 install is really an upgrade? you get the same result with
fewer steps.

Between 3.0 and 3.2 you just have to apply some DB schema changes. no
dump/reload crap necessary.

I did this successfully without incident.

Dump the current db, copy it over. Create the db using your database
admin tool, not make initialize-database. Restore the db dump on the
new server. Copy over /RT_BASE/ dir to the new box. Perform steps as
directed by Upgrade directions.

Andy Harrison