Rebuild, Repair or Change MySQL FULLTEXT index

Last Updated: 2006-09-27

To Repair, Rebuild or Reindex a MySQL Full Text search index you use:

Command:

mysql> REPAIR TABLE tbl_name QUICK;

If you have custom Full Text search settings in your configuration file it is recommended that you use the myisamchk command to avoid problems. All custom configuration settings, ft_min_word_len, ft_max_word_len, and ft_stopword, need to be specified.
The example below demonstrates a custom MySQL configuration setting where "ft_max_word_len" is set to 20 and "ft_min_word_len" is set to 2.

Command:

shell> myisamchk --recover --ft_min_word_len=2 --ft_max_word_len=20 tbl_name.MYI

NOTE: If you have not changed your MySQL configuration settings, this should not be needed. Check you settings:

Command:

shell> mysqld --verbose --help

Modifying the Full Text search can be accomplished with:

Command:

ALTER tbl_name ADD FULLTEXT [index_name] (index_col_name,...);

Originally Posted by Skylinux @ 2006-09-27 02:06:31

User Comments:

No Comments yet .....

Add Your Comment:

Note: All posts require administrator approval. Please allow 24 hours for message approval.

Name:
E-Mail:
Title