[rt-users] Version 3.8.1 upgrade - UPGRADING.mysql file clarification

[Todd Herr]

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