mysql - Where to change the value of lower_case_table_names=2 on windows xampp

Question

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 1

Do these steps:

1. open your MySQL configuration file: [drive]xamppmysqlinmy.ini
2. look up for: # The MySQL server [mysqld]
3. add this right below it: lower_case_table_names = 2
4. save the file and restart MySQL service

From: http://webdev.issimplified.com/2010/03/02/mysql-on-windows-force-table-names-to-lowercase/