[rt-users] upgrading to 3.8.2 from versions prior to 3.8.x

[jmoseley at corp.xanadoo.com]

Jesse Vincent <jesse at bestpractical.com> wrote:

On Wed, Jan 07, 2009 at 06:19:20PM -0600, jmoseley at corp.xanadoo.com wrote:

>> So, in the setup-database script, do you tell it to stop at 3.8.0, or
>> 3.7.87?  Meaning, if I choose 3.8.0, does the script stop after
installing
>> the 3.7.87 schema changes, or does it also include the 3.8.0 schema
>> updates?  Perhaps it doesn't matter.

>I don't believe it actually matters, but the intent was to stop before
>the 3.8.0 updates, run the script and continue. Documentation patches
>would be lovely.

How's this for a start:

--- UPGRADING.mysql     2009-01-06 19:15:20.000000000 -0600
+++ UPGRADING.mysql.patched     2009-01-09 08:34:51.000000000 -0600
@@ -19,7 +19,7 @@

 2) Follow instructions in the README file to step 7.

-3) Apply changes described in step 7, but only up to version 3.8.0.
+3) Apply changes described in step 7, but only up to and not including
version 3.8.0.

 4) Apply the MySQL 4.0->4.1 schema changes. Included in RT is the script
 etc/upgrade/upgrade-mysql-schema.pl that generates SQL queries to upgrade
the database's schema. Run it:
@@ -40,8 +40,8 @@
 your database from the backup you made at step 1) and send a report to the
 rt-users at lists.bestpractical.com mailing list.

-7) Continue from step 7 in the README and apply other upgrade scripts and
follow
-other steps.
+7) Continue from step 7 in the README and apply other mysql upgrade
scripts and follow
+remaining steps.

 8) Test everything. The most important parts you have to test:
 * binary attachments, like docs, PDFs, and images

James