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

 

No Comments yet .....