Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    9

    Unanswered: 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.

  2. #2
    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?

  3. #3
    Join Date
    Feb 2004
    Posts
    9
    how can I go to :
    [mysqld]
    ft_min_word_len=3




    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?

  4. #4
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •