Forum Moderators: open

Message Too Old, No Replies

ft min word len in IIS mysql

         

mcibor

2:24 pm on Oct 17, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Hi all,

I am stuck with a fulltext search in my local wiki.
I want to search for two letter abbreviations, like NY
but my MySQL 5.0 on command:
mysqld-nt --help --verbose
says:

ft_max_word_len 84
ft_min_word_len 4
ft_query_expansion_limit 20
ft_stopword_file (No default value)

I tried to change that setting in
C:\Program Files\MySQL\MySQL Server 5.0
in files
my-innodb-heavy-4G.ini
and added also to my.ini

after restarting mysql with command:
net stop mysql
net start mysql

nothing changes.

What can I do more to set this to 2 letters?

PS. I already tried adding
[mysqld]
ft_min_word_len=2
[myisamchk]
ft_min_word_len=2

but to no avail.

Thanks for your help!
Micha³

mcibor

8:59 pm on Oct 29, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Hi there, after poking more with mysqld-nt command line I managed to solve this issue (though I have no idea how). The my.ini is unchanged. But after restart it works as well.

So thanks anyway and till later!