Hello.
I'm still in the planning stages of an upgrade from 3.6.0, with MySQL
5.0.22, to 3.8.1, and I'm a bit confused by contents of the
UPGRADING.mysql file.
The file includes the line:
If you're upgrading RT from versions prior to 3.8.0 then you MUST follow
instructions below.
but those instructions all seem to speak to an upgrade of MySQL from 4.0
to 4.1, and I'm already running MySQL 5.0.22:
1) Backup RT database. It's really good to test that you can restore from
this backup.
2) Follow instructions in the README file to the step 7).
3) Apply changes described in the seven step, but only up to version 3.8.0.
4) Apply mysql 4.0->4.1 schema changes. RT tarball has script
etc/upgrade/schema.mysql-4.0-4.1.pl that generates SQL queries to
upgrade schema
of
the DB. Run it:
perl etc/upgrade/schema.mysql-4.0-4.1.pl db user pass > sql.queries
5) Check sanity of sql queries yourself or consult with your DBA
6) Apply queries. Note that this step can take a while. May require
additional
space on your hard drive comparable with size of your tables.
mysql -u root -p rt3 < sql.queries
So, my question is, do I have to follow the instructions in the
UPGRADING.mysql file, given that I'm already running MySQL 5.0.22?
--
Todd Herr
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
