[rt-users] advice on database upgrade

[Niels Bakker]

* 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.

--