How to reset stop words in MYSQL?

Question

I want to reset stop word list in mysql for FULLTEXT search. I have installed WAMP Server in my system which have phpmyadmin to access mysql. But I dont know how to reset stop word in phpmyadmin. Can anyone please tell me how to do that.

I also http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_ft_stopword_file read this link but don't know ho wto use this ???

"reset" as in "disable" stop words, or as in "change" stop words? — Aziz, Apr 28 '09 at 07:57

score 11 · Accepted Answer · answered Apr 28 '09 at 10:36

11

I assume you're using WampServer.

Click the tray icon, select MySQL, then click my.ini. The configuration file will open in notepad. Go to the end of the file and add this line (after the port line):

 ft_stopword_file=''

to disable stop words. If you want to use custom stop-word file, replace that line with:

ft_stopword_file='path/to/stopword_file.txt'

(set the path of the stopword file, of course).

After setting that line, save the configuration file (File -> Save). Then click the tray icon, select MySQL, then Service, then click Restart Service.

To Ensure that your configuration is done correctly, open phpMyAdmin in the browser, click on the Variables tab at the top, then find ft stopword file and see the values that is set to it.

answered Apr 28 '09 at 10:36

Aziz

20,065
8
63
69

Yes, I am using Wampserver, Thanks for this answer :) – djmzfKnm Jun 06 '09 at 15:05
Do we just separate words by a new line? How does mysql know how the words are delimited? – srchulo Nov 15 '11 at 04:09
@Aziz could you please tell me what is the structure of stopword_file.txt. – hungneox Dec 20 '11 at 07:03
1

@eureka: one word per line would work fine. You can also separate words by commas or spaces. – Aziz Dec 20 '11 at 09:10
The ft_stopword_file='' clause must be added under the [mysqld] section, which may not necessarily be at the end of the file. – dionyziz Mar 23 '13 at 10:46

Tom · Answer 2 · 2017-02-19T22:31:29.950

0

You can find a list of stop words to use here: https://dev.mysql.com/doc/refman/5.6/en/fulltext-stopwords.html. I saved this list to a file and referenced it from the MySQL config file (e.g. ft_stopword_file='path/to/stopword_file.txt').

I removed "it" and "us" from the stopword list because they mean "Information Technology" and "United States" in my problem domain.

Unfortunately, every time you change the stopword list you have to restart MYSQL and rebuild the full-text index's.

edited Feb 19 '17 at 22:31

answered Aug 05 '09 at 07:25

Tom

14,041
16
64
80

Link is broken. – jor Feb 17 '17 at 11:16

score 0 · Answer 3 · answered Dec 13 '13 at 13:13

0

i wass having same problem. stopwords file must be included under [mysqld] section in my.ini file.

[mysqld] ft_stopword_file = 'D:/stop.txt' then

repair table tablename worked for me.

answered Dec 13 '13 at 13:13

karan pujara

40
7

score 0 · Answer 4 · answered May 22 '11 at 08:19

I have got the same problem, I don't think you have to recompile anything, I've read that you can use the mysql console SET ft_stopword_file='path/to/stopword_file.txt', that should not require restarting your server. but I don;t think it will last till the next restart, so I guess I'll try the config file, and see if it works

thomasrutter · Answer 5 · 2012-09-05T00:11:19.367

0

The list of stopwords that MySQL ships with (at least for MyISAM) can be found in MySQL's source, in myisam/ft_static.c.

Note also that these are only the 'English' stopwords. Presumably, stopwords for other languages are defined elsewhere...

You can override or disable the default stopword list using the ft_stopword_file directive as pointed out in the comments. Full documentation here.

edited Sep 05 '12 at 00:11

answered Apr 28 '09 at 08:26

thomasrutter

114,488
30
148
167

I want to know how to disable or change the stop word list. That is not given in the article.... – djmzfKnm Apr 28 '09 at 08:48
You don't - you just need to add/edit my.conf. To use your own custom stopwords.txt: ft_stopword_file='path/to/stopword_file.txt' or to disable: ft_stopword_file="" You will need to rebuild your indexes though, using REPAIR or by dropping and readding them. – snipe Sep 04 '12 at 20:51

How to reset stop words in MYSQL?

5 Answers5

Linked