[rt-users] Upgrade to 4.01 MySQL questoin

[Paul O'Rorke]

no - actually I'm not.  I guess I have to change my plan.

I had thought to import the data - spend some time setting up 4.01 as I
wanted then update the DB by running the import again.  I guess this is not
such a good idea.  I'm thinking then that I'll have to make careful note of
the set up changes and do it all in one 'fell swoop'...

Unless there is a way to update my imported and 'patched' 4.01 DB with a
3.8.4 dump just to get the most recent changes.

Does what I'm trying to do make sense?

Thanks for the excellent help thus far btw.

Paulo

On Tue, Aug 9, 2011 at 2:16 PM, Kevin Falcone <falcone at bestpractical.com>wrote:

> On Tue, Aug 09, 2011 at 12:27:03PM -0700, Paul O'Rorke wrote:
> >    [Tue Aug 9 02:42:25 2011] [warning]: DBD::mysql::st execute failed:
> Unknown column
> >    'main.DelegatedBy' in 'where clause' at
>
> This implies that you have a partially upgraded database, since this
> column is deleted in 3.9.3
>
> Are you sure you're starting from a fully-clean restore of your 3.8.4
> dump?  You want to ensure that no existing tables are in your DB.
>
> -kevin
>
> --------
> RT Training Sessions (http://bestpractical.com/services/training.html)
> *  Chicago, IL, USA — September 26 & 27, 2011
> *  San Francisco, CA, USA — October 18 & 19, 2011
> *  Washington DC, USA — October 31 & November 1, 2011
> *  Melbourne VIC, Australia — November 28 & 29, 2011
> *  Barcelona, Spain — November 28 & 29, 2011
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110809/9b2edbfb/attachment.htm>