Virtual Brain Online Logo

Bookmark: Root \ Database \ Rebuild, Repair or Change MySQL FULLTEXT index

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

 

No Comments yet .....

 

Add Your Comment:

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

Name:
E-Mail:
Title
Plain text only, less then 65 000 characters.

Please remove the letter z from the word "zadzelskzronze" and tpye it into the answer box.

Please answer the question above and type the answer into the text box below.