[rt-users] advice on database upgrade

[Paul Grondahl]

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.

paul





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


* paul_grondahl at yahoo.com (paul_grondahl at yahoo.com) [Tue 09 Nov 2004,
01:43 CET]:
> 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.

--