I'll confess to still not quite being able to parse steps 2 and 3 in the
UPGRADING.mysql file; Follow instructions in the README file to the
step 7); Apply changes described in the seven step, but only up to
version 3.8.0.
Here's step 7 from README:
As a user with permission to install RT in your chosen installation
directory, type:
make upgrade
This will install new binaries, config files and libraries without
overwriting your RT database.
Update etc/RT_SiteConfig.pm in your RT installation directory.
You'll need to add any new values you need to change from the
defaults
in etc/RT_Config.pm
You may also need to update RT's database. You can do this with
the rt-setup-database tool. Replace root with the name of the dba
user on your database (root is the default for MySQL).
You will be prompted for your previous version of RT (such as 3.6.4)
so that we can calculate which database updates to apply
You should back up your database before running this command.
/opt/rt3/sbin/rt-setup-database --dba root
--prompt-for-dba-password --action upgrade
Clear mason cache dir:
rm -fr /opt/rt3/var/mason_data/obj
Stop and start web-server.
So, to clarify then...
untar distro
./configure -blahblahblah
make testdeps
make fixdeps
(lather, rinse, repeat as necessary)
backup database
make upgrade
perl etc/upgrade/schema.mysql-4.0-4.1.pl db user pass sql.queries
mysql -u root -p rt3 sql.queries
/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
--action upgrade
Is that the right sequence of steps, or does make upgrade come after the
schema upgrades?
Drew Barnes wrote:
Yup.
Todd Herr wrote:
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
703.220.4153
___
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
