[rt-users] Blank Comment

Leon rt at tux.datalink.co.za
Tue Jul 13 18:25:20 EDT 2004


Thanks,

I found this link :
http://manuals.thexdershome.com/mysql-4.0/manual_Table_types.html
To the MySQL manual. It states that i should be able to do a {... use 
|ALTER TABLE ... TYPE=INNODB ...}

Will this be sufficient on each table in my RT database ?

I really can't afford to lose my tickets, but i also need to upgrade to 
the next version as soon as it becomes available.

|Leon

Bret Martin wrote:

>On Tue, 13 Jul 2004 17:08:47 EDT Alex Vandiver wrote:
>  
>
>>  The solution is to use a MySQL server that supports InnoDB tables. 
>>Starting with RT 3.2.1, trying to install RT with a MySQL build that
>>doesn't support InnoDB tables will give an error.
>>    
>>
>
>I don't know if you care, but I noticed when installing RT 3.2.0 that
>the stanza that creates the "sessions" table in schema.mysql doesn't
>have "TYPE=InnoDB;" at the end, but all the other CREATE TABLEs do have
>it.
>
>At first I wasn't sure why that one table way MyISAM and the rest were
>InnoDB -- this was before I switched my MySQL configuration to have
>InnoDB as the default table type.
>
>Then again, maybe RT's use of that table doesn't require InnoDB
>functionality.  Seems like it would be nice to have the tables all of
>the same type though.
>
>--Bret
>
>
>_______________________________________________
>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
>Be sure to check out the RT wiki at http://wiki.bestpractical.com
>
>
>  
>



More information about the rt-users mailing list