Advice on database upgrade

RT Users
1

hello rt’ers,

i have just migrated our current rt system to new hw.

  • the old system runs rt 3.0.8, rtfm 2.0.1 on fc1 with mysql 4.0.13,
    apache 1.3.27, perl 5.8.0

  • the new system runs rt 3.2.2, rtfm 2.0.4 on RH EL3 with mysql 4.0.22,
    apache 1.3.31, perl 5.8.5

i transferred the database like this:

old server: mysqldump -p --opt rt3 | gzip >
/usr/MySQL-Backup/rt3.dump.gz

new server: gzip -dc rt3.dump.gz | mysql rt3

this appears to have worked. i can login and see all the old
tickets/queues/users on the new system.

my question is: will all the database schema changes between rt versions
remain intact now that i essentially “overwrote” the new database? is
this upgrade procedure kosher?

thanks,

paul grondahl

2

i have just migrated our current rt system to new hw.

  • the old system runs rt 3.0.8, rtfm 2.0.1 on fc1 with mysql 4.0.13,
    apache 1.3.27, perl 5.8.0

  • the new system runs rt 3.2.2, rtfm 2.0.4 on RH EL3 with mysql 4.0.22,
    apache 1.3.31, perl 5.8.5

i transferred the database like this:

old server: mysqldump -p --opt rt3 | gzip >
/usr/MySQL-Backup/rt3.dump.gz

new server: gzip -dc rt3.dump.gz | mysql rt3

The database schema has changed between these releases of RT, please
read the upgrade README for the proper procedure.

-- Niels.
3

perhaps i need to clarify:

on the new server i installed rt as if it was a new 3.2.2 install. that
includes the make initialize-database command. so, the schema was up to
date with rt 3.2.2. what i’m wondering is whether this schema was
overwritten when i restored from the 3.0.8 dump file.

paulFrom: Niels Bakker [mailto:niels=rt@bakker.net]
Sent: Monday, November 08, 2004 5:05 PM
To: paul_grondahl@yahoo.com
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] advice on database upgrade

i have just migrated our current rt system to new hw.

  • the old system runs rt 3.0.8, rtfm 2.0.1 on fc1 with mysql 4.0.13,
    apache 1.3.27, perl 5.8.0

  • the new system runs rt 3.2.2, rtfm 2.0.4 on RH EL3 with mysql
    4.0.22, apache 1.3.31, perl 5.8.5

i transferred the database like this:

old server: mysqldump -p --opt rt3 | gzip >
/usr/MySQL-Backup/rt3.dump.gz

new server: gzip -dc rt3.dump.gz | mysql rt3

The database schema has changed between these releases of RT, please
read the upgrade README for the proper procedure.

-- Niels.
4

on the new server i installed rt as if it was a new 3.2.2 install. that
includes the make initialize-database command. so, the schema was up to
date with rt 3.2.2. what i’m wondering is whether this schema was
overwritten when i restored from the 3.0.8 dump file.

Yes, the schema will have been overwritten when you reloaded from your
old dump. The file you uploaded has ‘DROP TABLE’ lines in it, so you
deleted the tables that RT installed and replaced them with the
versions from your old dump file.

Hope this helps.

  • Jason Parsons