raghavan20 wrote:it is asking me to login..could you please paste the relevant information
Interesting I got in without login )
Try the following:
* Put the following in an option file:
[mysqld]
ft_min_word_len=3
* Restart server.
* Rebuild your FULLTEXT indices:
mysql> REPAIR TABLE tbl_name QUICK;
NOTE: if you use myisamchk to perform an operation, i.e. repair, that modifies table indices put the following in an option file:
[myisamchk]
ft_min_word_len=3
Try onther browser or something it should not require any login
The topic is not very short.
....some posts later.
Thanks, it's working good now. Where should I store my custom stop words list? I tried placing it in the /ect/ directory on my server, but it doesn't seem to find it. Is there a good place to store this?
I did put the ft_min_word_len option in the my.ini file in the base dir of mysql 5 but still it reads these options somewhereelse...anybody have got any idea where it reads from other than the ini file in basedir. I do not see min and max word options in this file before I put my custom option in it...
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306
#full text minimum word length
ft_min_word_len=2
#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"
#Path to the database root
datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"
# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1
# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
# The maximum amount of concurrent sessions the MySQL server will
# allow. One of these connections will be reserved for a user with
# SUPER privileges to allow the administrator to login even if the
# connection limit has been reached.
max_connections=100
# Query cache is used to cache SELECT results and later return them
# without actual executing the same query once again. Having the query
# cache enabled may result in significant speed improvements, if your
# have a lot of identical queries and rarely changing tables. See the
# "Qcache_lowmem_prunes" status variable to check if the current value
# is high enough for your load.
# Note: In case your tables change very often or if your queries are
# textually different every time, the query cache may result in a
# slowdown instead of a performance improvement.
query_cache_size=0
# The number of open tables for all threads. Increasing this value
# increases the number of file descriptors that mysqld requires.
# Therefore you have to make sure to set the amount of open files
# allowed to at least 4096 in the variable "open-files-limit" in
# section [mysqld_safe]
table_cache=256