Hi James, Yes I have verified whether the variable has changed with show variables, and it has not changed as per my first email. I have not gotten to rebuilding as the variable just will not change ;-)
Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . * Web Design and Development * SMS Solutions, including developer API * Domain Registration, .COM for as low as fifteen dollars a year, .COM.AU for fifty dollars two years! -----Original Message----- From: James Harvard [mailto:[EMAIL PROTECTED] Sent: Monday, 24 April 2006 10:11 PM To: mysql@lists.mysql.com Subject: Re: Fulltext 3 letter words You can find out whether the server has picked up the changes from your configuration file by running the following SQL: show variables like 'ft_min_word_len'; As per the instructions in the manual http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html you must rebuild the indexes on any tables with a full-text index. Also, note the warning about using myisamchk further down the manual page. HTH James Harvard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
