CODEWITHSUNDEEP
phpmysqlsearchfull-text-search
sumit
sumit

Reputation: 11257

MySQL table not supporting FULLTEXT index

I am using MySQL with InnoDB engine for my website. While creating a table with FULLTEXT index, it is throwing an error:

"The used table type doesn't support fulltext indexs"

What are the alternatives I can use? I don't want to use MyISAM because InnoDB is more advanced. Any way to remove this error?

I am using PHP, MySQL, Apache on Windows machine.

Upvotes: 0

Views: 3684

Answers (2)

Mchl
Mchl

Reputation: 62387

Wait until MySQL 5.6 - InnoDB is going to support FULLTEXT searches since then ;)

But if you can't wait, you can use for example SphinxSE, which lets you use Sphinx fulltext search engine on your MySQL tables with plain SQL

Upvotes: 3

Pascal MARTIN
Pascal MARTIN

Reputation: 401002

FULLTEXT indexes are only supported by the MyISAM engine ; so, if you want your table to be in InnoDB, you won't have much of a choice.

If fulltext searching is an important part of your website/application, you might want to use something else than database, for the indexing/searching part -- typically, some dedicated solution, like Solr.

Upvotes: 4

Related Questions