If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Setting the ft_min_word_len for fulltext searching

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-08-04, 13:39
barry_1030 barry_1030 is offline
Registered User
 
Join Date: Feb 2004
Posts: 9
Setting the ft_min_word_len for fulltext searching

Hi, every body

I'm using windows XP and MySQl 4.0.17.
I would like to set the ft_min_word_len for fulltext searching.
I try to set it in my.ini, but it fail.
Also, I type in the following command:

1. C:\mysql/bin>mysqld -O ft_min_word_len=2
2. mysql> set-variable=ft_min_word_len=2


All of them are fail.

Can anyone give me any suggestion?
Please help.
Reply With Quote
  #2 (permalink)  
Old 02-08-04, 18:22
vanekl vanekl is offline
Registered User
 
Join Date: Nov 2003
Posts: 91
I run 4.0.17 on Win XP and this works for me:

[mysqld]
ft_min_word_len=3

Then restart the server and rebuild your FULLTEXT indexes:

mysql> REPAIR TABLE tbl_name QUICK;


Are you forgetting to restart the server?
Are you forgetting to rebuild the fulltext indexes?
Reply With Quote
  #3 (permalink)  
Old 02-09-04, 05:04
barry_1030 barry_1030 is offline
Registered User
 
Join Date: Feb 2004
Posts: 9
how can I go to :
[mysqld]
ft_min_word_len=3




Quote:
Originally posted by vanekl
I run 4.0.17 on Win XP and this works for me:

[mysqld]
ft_min_word_len=3

Then restart the server and rebuild your FULLTEXT indexes:

mysql> REPAIR TABLE tbl_name QUICK;


Are you forgetting to restart the server?
Are you forgetting to rebuild the fulltext indexes?
Reply With Quote
  #4 (permalink)  
Old 02-09-04, 10:05
vanekl vanekl is offline
Registered User
 
Join Date: Nov 2003
Posts: 91
There should be a my.ini file in your c:\WINDOWS directory.
Open it with a text editor.
You should see this line in the file:
[mysqld]
Beneath this line, add the following line:
ft_min_word_len=3
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On