Lowercase and uppercase table names

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Lowercase and uppercase table names

Postby NeilSwartz » 09. February 2012 18:23

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!!!
NeilSwartz
 
Posts: 10
Joined: 27. March 2007 03:38
Location: Chicago
Operating System: WimXP & Win7

Re: Lowercase and uppercase table names

Postby hackattack142 » 10. February 2012 01:34

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.
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 703
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: Lowercase and uppercase table names

Postby NeilSwartz » 10. February 2012 01:42

Not using "set-variable=" worked. Thank you.
NeilSwartz
 
Posts: 10
Joined: 27. March 2007 03:38
Location: Chicago
Operating System: WimXP & Win7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 53 guests