[MySQL] Table names changed to lower-case..

[r_honey]

I'm running MySQL 5.0.41-community-nt on a Win32 machine. Each time I create a new table the table and field names are changed to lowercase!

 

I have already changed the MySQL directive lower_case_table_names to 0 in my.ini in my Windows directory and added the following line to the group [mysqld]:

 

set-variable = lower_case_table_names=0

 

Still, here's my complete my.ini file:

 

#This File was made using the WinMySQLAdmin 1.4 Tool

#6/22/2007 11:15:36 PM

 

#Uncomment or Add only the keys that you know how works.

#Read the MySQL Manual for instructions

 

[mysqld]

basedir=N:/xampp/mysql

#bind-address=22.23.13.1

datadir=N:/xampp/mysql/data

#language=N:/xampp/mysql/share/your language directory

#slow query log#=

#tmpdir#=

#port=3306

#set-variable=key_buffer=16M

set-variable=lower_case_table_names=0

[WinMySQLadmin]

Server=N:/xampp/mysql/bin/mysqld-nt.exe

user=root

password=passwd

 

Can anyone tell me the solution????

[wildteen88]

Did you restart the MySQL server? You must restart the MySQL server when you modify the my.ini file

[r_honey]

Obviously...

Morover, I restarted the whole system itself!!! multiple times....