Let's make it clear: * you still must upgrade DB using files in etc/upgrade/x.x.x/ * however in 3.8.0 you can do it using one command:
rt-setup-database --dba root --prompt-for-dba-password --action upgrade it will ask for the old version (for example you can enter 3.6.7) and will apply all steps up to the installed version (in this case it's 3.8.0) * then you do mysql schema changes using the script * these schema changes are required for all mysql versions greater than mysql 4.1.0 * people installing for the first time will get new DB schema as there are two different schema files for mysql in etc/, so they don't need to do all these steps * people upgrading mysql server from 4.0 to 4.1 and newer should use the script two * I tested this script several times, but only on my dev PC, so it's VERY recommended to backup and make tests Clear? On Wed, Jul 16, 2008 at 8:03 PM, <[EMAIL PROTECTED]> wrote: > Interesting. We're running 5.0.27 and the script worked just fine. > However, I ran all the schema/acl/insert upgrade commands using all the > 5.7.xx directories in etc/upgrade. > > Still waiting to hear from Ruslan to confirm 100% that you don't need to > run all these commands and you need only run the schema.mysql-4.0-4.1.pl > script. > > Additionally, not entirely sure, but it sounds like he acknowledges there > is a problem with the script. > > > James Moseley > > > > > > "Ryan Hardester" > <[EMAIL PROTECTED] > i.tracy.ca.us> To > "Ruslan Zakirov" > 07/16/2008 10:41 <[EMAIL PROTECTED]>, > AM <[EMAIL PROTECTED]> > cc > <[email protected]> > Subject > RE: [rt-users] Upgrading to 3.8.0: > schema.mysql,column_info selection > problem > > > > > > > > > > > I am getting the same column_info failed error message when running the > script. I'm using mysql5.0.22 on Ubuntu. I did have to move this file to > the DB server since we are not running RT and the DB on the same > machine. > > --Ryan > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ruslan > Zakirov > Sent: Wednesday, July 16, 2008 6:57 AM > To: [EMAIL PROTECTED] > Cc: [email protected] > Subject: Re: [rt-users] Upgrading to 3.8.0: schema.mysql,column_info > selection problem > > In 3.8.0 it's one step :) > > However, we've done changes to mysql DB that require additional > upgrade steps for mysql, and this step fails. > > On Wed, Jul 16, 2008 at 5:24 PM, <[EMAIL PROTECTED]> wrote: >> Did you follow these steps first? >> >> You may also need to update RT's database. To find out, type: >> >> ls etc/upgrade >> >> For each item in that directory whose name is greater than >> your previously installed RT version, run: >> >> /opt/rt3/sbin/rt-setup-database --action schema \ >> --datadir etc/upgrade/<version> >> /opt/rt3/sbin/rt-setup-database --action acl \ >> --datadir etc/upgrade/<version> >> /opt/rt3/sbin/rt-setup-database --action insert \ >> --datadir etc/upgrade/<version> >> >> >> There are 10 3.7.xx directories that you'll need to go through. >> >> >> James Moseley >> >> >> >> >> >> "web master" >> <[EMAIL PROTECTED] >> ra.com> > To >> Sent by: [email protected] >> rt-users-bounces@ > cc >> lists.bestpractic >> al.com > Subject >> [rt-users] Upgrading to 3.8.0: >> schema.mysql, column_info >> 07/16/2008 05:00 selection problem >> AM >> >> >> >> >> >> >> >> >> >> Hi there >> I am having schema.mysql-4.0-4.1.pl problems upgrading to version >> 3.8.0 from 3.6.6. >> make upgrade worked well. >> >> As in point 4) of UPGRADING.mysql >> >> [EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl > sql.queries >> >> but >> >> usage: etc/upgrade/schema.mysql-4.0-4.1.pl db_name db_user db_password >> >> Ok, then I inserted the info needed >> >> [EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl DB USER PASS > > sql.queries >> >> but >> >> DBD::mysql::db column_info failed: column_info doesn't support column >> selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227. >> DBD::mysql::db column_info failed: column_info doesn't support column >> selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227. >> >> RT 3.6.6 was installed a month ago on MySQL 5.0, maybe I do not need >> to run chema.mysql-4.0-4.1.pl, but UPGRADING.mysql (not present in >> 3.6.6 tarball), it seems to suggest so. >> >> Can anybody please help? >> Cheers >> _______________________________________________ >> 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 >> >> >> _______________________________________________ >> 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 >> > > > > -- > Best regards, Ruslan. > _______________________________________________ > 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 > > > -- Best regards, Ruslan. _______________________________________________ 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
