MySQL: How to refresh a Fulltext Index
Question by Compi | 2016-03-10 at 12:43
I have made some changes at my database and an existing fulltext index - I have extended the index to more columns and I have adjusted the value for ft_min_word_len.
Unfortunately, those changes have not changed the already existing index at all, there are still the old words in. How can I manually achieve that MySQL is rebuilding and refreshing the index again?
Related Topics
SQLite: Creating an Index on one or more Columns
Info | 0 Comments
MySQL: Change minimum word length for full text search
Tip | 1 Comment
HTACCESS: Simplify URL
Tutorial | 0 Comments
Multiple Index Files: Force Server to load index.php instead of index.html
Question | 2 Answers
Darken Background of a Website (Gray Out Effect)
Tutorial | 0 Comments
PHP: Create Array with arbitrary Index - Index should not start at 0 and can have Gaps
Question | 1 Answer
MySQL: 3 Ways of showing Table Definition and Structure
Info | 0 Comments
Important Note
Please note: The contributions published on askingbox.com are contributions of users and should not substitute professional advice. They are not verified by independents and do not necessarily reflect the opinion of askingbox.com. Learn more.
Participate
Ask your own question or write your own article on askingbox.com. That’s how it’s done.
If you would like to have a complete rebuild of your index, you can execute the following command (tab is standing for the name of your table in which the index is located):
Alternatively, it is also possible to delete the old index in order to create the new index (with the changes) afterwards. When doing so, the index is directly built in the right way.
2016-03-10 at 13:51