How Do I Rebuild Fulltext Index for v7.1?

vei · February 11th, 2012, 09:15 PM

Its my understanding that PP uses mySQL fulltext indexing.

I have to change the mySQL ft_min_word_len from the default of 4 to 3. mySQL says you have to rebuild fulltext indices after this move.

How can I do this for pp 7.1?

Chuck S · February 11th, 2012, 09:30 PM

The mysql site should have information about rebuilding index's as that is not handled through software side. That is handled through mysql.

vei · February 12th, 2012, 10:58 AM

i need to know which of your tables have a fulltext index

Chuck S · February 12th, 2012, 11:17 AM

The answer is no table. Our tables have indexes on certain fields but none are fulltext I beleive I see nothing in our table statements as such.

vei · February 13th, 2012, 11:46 AM

Thanks Chuck. That will make it much easier.

Chuck S · February 13th, 2012, 01:51 PM

Not a problem glad to help.