Page 1 of 1

Ubuntu. Setting MySQL ft_min_word_len .

PostPosted: 19. January 2010 10:05
by The Other Steve
Hello.

I'm sorry, but I am having trouble setting ft_min_word_len . :(

I did read the my.cnf file, and I appended the mysqld entry

[mysqld]
ft_min_word_len = 2

and then saved my.cnf to /etc/ . I stopped and restarted XAMPP, and then the machine. No change to the variable ft_min_word_len in either case.

I saved the my.cnf file to /opt/lampp/var/mysql/ and then also ~/.my.cnf with the same results. I tried all permutations: the same my.cnf file in two of the above directories, the same file in all three directories. No change in the variable after machine restart.

What am I doing wrong?

:?

Re: Ubuntu. Setting MySQL ft_min_word_len .

PostPosted: 22. April 2010 05:04
by jacinto
hey, i came across the same question too today. you need to run:
REPAIR TABLE tbl_name QUICK
in mysql command.