[support] Full-text data search in InnoDB tables

Kamal Palei palei.kamal at gmail.com
Mon Aug 27 12:43:46 UTC 2012


Hi All
I am using Drupal 6.26, MySql (innodb).

I tried to first to do full text data search in InnoDB table.
A simple query statement is shown as below.

*SELECT * FROM resubmt_skill_ids WHERE MATCH (name) AGAINST ('java')*

But I get the below error.

#1214 - The used table type doesn't support FULLTEXT indexes

On further google search, came to know, only MyISAM type tables support
full-text search.
I am bit reluctant to change my tables from InnoDB to MyISAM.
Can somebody suggest me is it not possible to do full-text search in InnoDB
tables.
Came across
http://blogs.innodb.com/wp/2011/07/innodb-full-text-search-tutorial/ have
not gone completely, but it looks author tells full-text search possible
with innodb tables.

If anybody has used full-text search on innodb tables, please let me know,
how to do that from drupal perspective .

Best Regards
Kamal
NECS, Bangalore
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20120827/82dffb69/attachment.html 


More information about the support mailing list