[rt-users] advice on database upgrade

paul_grondahl at yahoo.com paul_grondahl at yahoo.com
Mon Nov 8 19:43:05 EST 2004


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






More information about the rt-users mailing list