Linux.com

Re:Question about MyISAM to InnoDB with FULLTEXT

Posted by: Keith Winston on July 20, 2005 07:08 PM
AFAIK, you would have to leave the tables that use the FULLTEXT feature as MyISAM. You could convert the other tables to InnoDB. The only other solution I can think of is to move the text search into your application code which would be difficult and probably slower. Each storage engine has advantages and disadvantages. Good luck!

#

Return to MySQL migration: MyISAM to InnoDB