0

I am switching some MySQL tables from MyISAM to InnoDB:

What should I use in place of FULLTEXT?

As InnoDB does not have FULLTEXT. What should I use in FULLTEXT's place, when switching from MyISAM to InnoDB?

Thanks all : )

Regards.

  • 1
    A similar question? http://stackoverflow.com/questions/1228672/converting-table-from-myisam-to-innodb. In a nutshell `ALTER TABLE tablename DROP INDEX column_with_fulltext;` And then `ALTER TABLE tablename ENGINE=InnoDB;` – Mr. Radical Feb 04 '13 at 23:40
  • Maybe I am not wording this correctly. What should I use in place o FULLTEXT - as InnoDB does not have FULLTEXT. What should I use in FULLTEXT's place, when switching from MyISAM to InnoDB –  Feb 05 '13 at 02:43
  • 1
    You can use third-part application like Sphinx. There is no any built-it mechanism to replace fulltext search. – ravnur Feb 05 '13 at 07:39
  • Perhaps the answer should be "here is not any built-it mechanism in InnoDB to replace fulltext search"? Can anyone corroborate? –  Feb 06 '13 at 00:28

1 Answers1

1

Starting with MySQL 5.6.4 fulltext indexes are supported for InnoDB. http://dev.mysql.com/doc/refman/5.6/en/fulltext-restrictions.html

Mitch McBride
  • 66
  • 2