Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a VPS server with a company called Webfusion. I want to remove some or all of the FULLTEXT stopwords because some specific words needs to be searchable with my DB content. I opened /etc/mysql/my.cnf and added the line ft_stopword_file="". I restarted the mysql service, ran a repair table and then tried my MATCH query with no success.

I ran SHOW VARIABLES LIKE 'ft_%' and it simply shows (built-in) next to the stopword file.

I am running WAMP on my workstation, and whilst I realise this isn't configured the same as a commercial VPS, the above method worked just fine.

Couple someone please offer some guidance?

share|improve this question

1 Answer 1

up vote 0 down vote accepted

Seems obvious now, but I had to enter that variable right under the [mysqld] line and everything works now. Other forum responses had simply said to place it at the end of the file which didn't work for me.

[mysqld]
set-variable=local-infile=0
ft_min_word_len=3
ft_stopword_file=''
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.