Click to See Complete Forum and Search --> : changing table storage engines


ukndoit
04-04-2010, 09:05 AM
If I were to change from MyISAM to InnoDB will it lose or effect any current records at all?

How about in Perl, while using Apache::Sesssion::MySQL, the a_sessions field in the table is 'fulltext' so when I tried to change the record type, it would not let me as fulltext is not supported by InnoDB, so if I remove the fulltext index will that hurt the session programming?

thanks,
Richard