Mysql – locating the.cnf or the.ini file for MySQL

MySQL

I want a standard way to locate mysql config directories, On linux this becomes a little easy with mysqld –help –verbose, but I am still little puzzled how to get the install directories ( that's where I suppose the my.ini file should be).
I would most appreciate if we could get these search paths using a sql query statement ( show ??)

Update: I am specifically looking for a way to do it on Windows. I know so far that my.ini is kept in windows MySQL install dir, but through query how do I ascertain this location?

Best Answer

What about

# whereis my.cnf
my: /etc/my.cnf /etc/my.stopwords

(tested this on RHEL 5)

Related Solutions

Ubuntu – MySQL ignoring the.cnf

without knowing more details of what you changed, and assuming your mysql reads the /etc/mysql/my.cnf file fine (I don't know Ubuntu), the only thing I can think of is where you placed the innodb settings. Are the settings in the [mysqld] group?

According to the manual : "You can place InnoDB options in the [mysqld] group of any option file that your server reads when it starts."

MySQL – Changing FT_MIN_WORD_LEN (the.ini)

You may also want to create a custom stopword list because there are 640 words that are excluded from FULLTEXT indexes. Some of those two letter words omitted are: on, of, it, is. Take a look at the full list.

Perform the following

Step 01) Create a stopwords.txt file

echo "a" > C:\mysql_stopwords.txt
echo "an" >> C:\mysql_stopwords.txt
echo "the" >> C:\mysql_stopwords.txt

Step 02) Add these line to my.ini

[mysqld]
ft_min_word_len=2
ft_stopword_file=C:/mysql_stopwords.txt

Step 03) Restart mysql

net stop mysql
net start mysql

Step 04) Reindex all FULLTEXT indexes

Sorry I forgot this was Windows. I changed my answer to reflect Windows,

Best Answer

Related Solutions

Ubuntu – MySQL ignoring the.cnf

MySQL – Changing FT_MIN_WORD_LEN (the.ini)

Related Topic