CODEWITHSUNDEEP
mysql
TuK
TuK

Reputation: 3556

Setting MySQL "lower_case_table_name" server variable

Running MYSQL 5.1 on windows 7. . . how do I change the server variable for 'lower_case_table_names'. Need to set it to 0. I've tried to set it from the command prompt using mysqld.exe, and I've tried manually changing the my.ini file. . . no luck.

Does anyone have some sure-fire/straight-forward do-this, and then this instructions ?

Upvotes: 2

Views: 4923

Answers (2)

TuK
TuK

Reputation: 3556

Figured it out. . . couldn't change the variable w/ mysql workbench running. Closed it out, restarted the service and the changes took effect. Weird.

Upvotes: 2

user330315
user330315

Reputation:

As far as I know this will only affect new tables, existing tables will not be affected by this property.

Upvotes: 1

Related Questions