[rt-users] Migration Prep

[Asif Iqbal]

On Fri, Aug 2, 2013 at 10:48 AM, Kevin Falcone <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?





-- 
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130802/e3e2e388/attachment.htm>