Help talk:Short words in searches
From Meta, a Wikimedia project coordination wiki
How to restart mysql depends on your OS. Telling people that starting mysql with mysqld_safe is inappropriate for many systems, and can be insecure if, for example, they normally run mysql with --skip-networking. Or it can wreak havoc if they normally start it with --timezone=UTC0 -- Bilbo1507 19:24, 5 October 2006 (UTC)
Works like a charm
- Change the /etc/mysql/my.cnf add the ft_min_word_len=3 setting in [mysqld] and [isamchk].
- Restarted the mysqlserver (/etc/init.d/mysql restart),
- Optional: confirm with myphpadmin the value of ft_min_word_len has changed from 4 to 3.('Show MySQL system variables' from teh server menu)
- Run the 'php /www/wiki/maintenance/rebuildtextindex.php' script to rebuild the index.
Done 80.126.111.189 07:07, 27 March 2007 (UTC)
