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