Where to change the value of lower_case_table_names=2 on windows xampp
I am using windows 7 and xampp i am trying to export my database and while in the process the table names are converted to lower case. I have searched a lot, i know i have to change the value of lower_case_table_names from 0 to 2 but where i have to change this value, in which file?
Answer
Do these steps:
- open your MySQL configuration file: [drive]\xampp\mysql\bin\my.ini
- look up for:
# The MySQL server [mysqld] - add this right below it:
lower_case_table_names = 2 - save the file and restart MySQL service
From: http://webdev.issimplified.com/2010/03/02/mysql-on-windows-force-table-names-to-lowercase/