[rt-users] Migration Prep

[Kevin Falcone]

On Fri, Aug 02, 2013 at 11:21:24AM -0400, Asif Iqbal wrote:
>    On Fri, Aug 2, 2013 at 10:48 AM, Kevin Falcone <[1]falcone at bestpractical.com> wrote:
> 
>      You can look at 'show create table sessions' which should be innodb
>      not myisam and look at your Attributes table, which should have a
>      LONGBLOB for Content.
> 
>    I just did my test upgrade from rt 3.8.2 / mysql 5.0.75 to rt 4.0.16 / mysql 5.5.32
>    but session table still showing myisam.
>    $ mysql -e 'use rt4; show create table sessions'
>    | sessions | CREATE TABLE `sessions` (
>    `id` varbinary(32) NOT NULL DEFAULT '',
>    `a_session` longblob,
>    `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
>    PRIMARY KEY (`id`)
>    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
>    I guess I can just ALTER the session table now?

Please show a log of your make upgrade-database step

One of the steps explicitly drops and recreates the sessions table.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130802/5ac4b824/attachment.sig>