Windows 7 MySQLServer 5.5 - How to set lower_case_table_names mysqld setting
Posted on 2011-09-28
How do I set this value. I intend to solely use InnoDb so MyIsam corruption is not an issue
I have tried adding the same statement that works on a windows 7 MySQL Server
Dsitribution 5.1.48 but fails to work the same way on 5,5 distribution.
I tried adding the parameter to the startup:
Does anyone know other than:
C:\tmp\staffing>"C:\MySQL\MySQL Server 5.5\bin\mysqld" --lower_case_table_names=0 --defaults-file="C:\ProgramData\MySQL\Data\my.ini" MySQL55
110928 9:44:38 [Warning] You have forced lower_case_table_names to 0 through a command-line option, even though your file system 'C:\MySQL\MySQL Server 5.5\dat
a\' is case insensitive. This means that you can corrupt a MyISAM table by accessing it with different cases. You should consider changing lower_case_table_nam
es to 1 or 2
Is there a way to get this working in 5.5 just for InnoDb Storage Engine tables??
I need to keep my table and column naming case sensitive whether on a Win 7 or Solaris machine
Does anyone have any ideas how to do this in Version 5.5 ???