Comments on: How to disable mysql fulltext stopwords? https://www.nivas.hr/blog/2009/09/15/how-to-disable-mysql-fulltext-stopwords/ This is a blog from the Nivas.hr crew to the galaxy of unknown. Mon, 17 Jul 2017 06:02:07 +0000 hourly 1 https://wordpress.org/?v=5.8.2 By: Leonardo https://www.nivas.hr/blog/2009/09/15/how-to-disable-mysql-fulltext-stopwords/comment-page-1/#comment-1090482 Mon, 17 Jul 2017 06:02:07 +0000 https://www.nivas.hr/blog/?p=1468#comment-1090482 Thanks a lot!!!

In my case, i just created a new “Parameter Groups” from standard in RDS (Amazon AWS) with ft_stopword_file set to “/dev/null”
For everyone with the same problem: After that, just modify the parameter in the RDS instance, reboot RDS and use the

REPAIR TABLE tbl_name QUICK

Regards

]]> By: seven https://www.nivas.hr/blog/2009/09/15/how-to-disable-mysql-fulltext-stopwords/comment-page-1/#comment-1071769 Tue, 15 Nov 2016 13:21:46 +0000 https://www.nivas.hr/blog/?p=1468#comment-1071769 In reply to reda aloui.

it’s not a specific file, it’s mysql configuration file – my.cnf usually

]]> By: reda aloui https://www.nivas.hr/blog/2009/09/15/how-to-disable-mysql-fulltext-stopwords/comment-page-1/#comment-1040124 Sat, 06 Feb 2016 14:35:28 +0000 https://www.nivas.hr/blog/?p=1468#comment-1040124 hi,

can you pls tell me where to find the wamp stopwords file ?

regards

]]> By: Misha https://www.nivas.hr/blog/2009/09/15/how-to-disable-mysql-fulltext-stopwords/comment-page-1/#comment-1025150 Fri, 16 Oct 2015 22:28:03 +0000 https://www.nivas.hr/blog/?p=1468#comment-1025150 Hello, I never downloaded and installed MySQL files locally. I have shared hosting service and don’t have private virtual server. How can I edit my.cfn file or where can I find it? P.S. I use phpMyAdmin. Thanks

]]> By: Manish https://www.nivas.hr/blog/2009/09/15/how-to-disable-mysql-fulltext-stopwords/comment-page-1/#comment-755960 Sat, 09 Feb 2013 09:51:17 +0000 https://www.nivas.hr/blog/?p=1468#comment-755960 Thanks dude, works like a magic.

]]> By: seven https://www.nivas.hr/blog/2009/09/15/how-to-disable-mysql-fulltext-stopwords/comment-page-1/#comment-755737 Fri, 17 Feb 2012 12:22:58 +0000 https://www.nivas.hr/blog/?p=1468#comment-755737 LOL! Glad it worked out for you. Yes, we are using our site as a playground for SEO tests, and some of them actually work. :)

]]> By: Scott Donnelly https://www.nivas.hr/blog/2009/09/15/how-to-disable-mysql-fulltext-stopwords/comment-page-1/#comment-755730 Thu, 09 Feb 2012 21:49:37 +0000 https://www.nivas.hr/blog/?p=1468#comment-755730 Hey Nivas Guys,

Thanks for the great tip – I’d been tearing my hair out trying to find out why my website search function was not finding anything containing the word “best”. Searched Google for “mysql full text ignore stop words” and this was the 3rd non- dev.mysql.com result.

Thanks Again.

]]> By: Dr M https://www.nivas.hr/blog/2009/09/15/how-to-disable-mysql-fulltext-stopwords/comment-page-1/#comment-755478 Tue, 12 Jul 2011 13:17:06 +0000 https://www.nivas.hr/blog/?p=1468#comment-755478 Great tip..!
For me it worked like a charm..
The only thing I had to do is to add the line in my.cnf and restart MySQL..

;)

]]> By: Jonathan https://www.nivas.hr/blog/2009/09/15/how-to-disable-mysql-fulltext-stopwords/comment-page-1/#comment-744395 Mon, 29 Nov 2010 04:04:00 +0000 https://www.nivas.hr/blog/?p=1468#comment-744395 Thanks for the tip, I also found that it needs to be in the [mysqld] section of the my.cnf file to be taken into account after restart.

]]> By: Florian Schröck https://www.nivas.hr/blog/2009/09/15/how-to-disable-mysql-fulltext-stopwords/comment-page-1/#comment-725007 Thu, 23 Sep 2010 12:55:50 +0000 https://www.nivas.hr/blog/?p=1468#comment-725007 a note from the manpage:

Note: FULLTEXT indexes must be rebuilt after changing this variable or the contents of the stopword file. Use REPAIR TABLE tbl_name QUICK.

]]> By: rit https://www.nivas.hr/blog/2009/09/15/how-to-disable-mysql-fulltext-stopwords/comment-page-1/#comment-690946 Mon, 01 Mar 2010 08:15:19 +0000 https://www.nivas.hr/blog/?p=1468#comment-690946 hi, i try to put
ft_stopword_file = “” on my mysql configuration file ( my.ini) , and its not working. can u help me??
im using WAMP server version 1.7.2
thank u.

]]> By: Chris Roland https://www.nivas.hr/blog/2009/09/15/how-to-disable-mysql-fulltext-stopwords/comment-page-1/#comment-671278 Tue, 06 Oct 2009 00:28:05 +0000 https://www.nivas.hr/blog/?p=1468#comment-671278 Awesome, thanks for the help. I was seriously losing my mind.

]]>