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????