[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