Page 1 of 1

Lowercase and uppercase table names

PostPosted: 09. February 2012 18:23
by NeilSwartz
Exactly how do i change my.ini to allow lowercase & uppercase names???

In v166a I added set-variable=lower_case_table_names=0 to my.cnf. In v177 when I add this line MySql no longer loads!!!

Re: Lowercase and uppercase table names

PostPosted: 10. February 2012 01:34
by hackattack142
See http://dev.mysql.com/doc/refman/5.5/en/ ... able_names

I am sure there have been large changes between those two version, especially to MySQL. The syntax may be different now, I am not sure which version of MySQL 1.6.6 uses. Typically, in the new versions, to add a custom variable to the my.ini file, it would be like
Code: Select all
lower_case_tabe_names = 0
I have not seen the "set-variable=" syntax in the newer versions.

Re: Lowercase and uppercase table names

PostPosted: 10. February 2012 01:42
by NeilSwartz
Not using "set-variable=" worked. Thank you.