Andy, I followed these steps, following the UPGRADING UPGRADING.mysql docs and other messages in this list, in particular, Tim Cutts and Ruslan posts[1]:
# Set up a new RT box, install the new version of MySQL you want to use, and install RT 3.8.1. # Dump of your production MySQL instance, and load it into the new MySQL database. # Follow the UPGRADING.mysql document if you're going to upgrade your mysql server or move RT DB to a newer mysql server. 1) cd /path/to/rt-3.8.1-src/ 2) ./sbin/rt-setup-database --dba root --action upgrade # Select option to go only as far as version 3.8.0 3) rm -fr /var/run/rt38/mason_data/obj/ && apachectl restart 4) perl ./etc/upgrade/schema.mysql-4.0-4.1.pl rt3 root > sql.queries # Run the MySQL upgrade script, as detailed in UPGRADING.mysql, and apply the SQL statements it wants you to make. This takes a while. 5) mysql -u root -p rt3 < sql.queries 6) ./sbin/rt-setup-database --dba root --action upgrade # Run "/opt/rt3/sbin/rt-setup-database --action upgrade" again for the last small changes from 3.8.0 to 3.8.1 Despite the fact that we did have a problem in our database in the step 5 above, I've sent the steps above to this list a few days ago and it seems these are ok, as nobody - including Ruslan - told me otherwise. Reference: [1] http://www.mail-archive.com/rt-users@lists.bestpractical.com/msg16831.html Best regards, Alex
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com