Help talk:Short words in searches

From Meta, a Wikimedia project coordination wiki
Jump to navigation Jump to search

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)[reply]

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 07:07, 27 March 2007 (UTC)[reply]