如何通过PHP中的运行时脚本禁用MySQL中的大小写敏感性

Question

I had to import a MySQL backup from a Windows server to a Linux server. As table names were in both upper and lower case in the previous database, I have problem right now because in current server (Linux) settings are case insensitive mode for MySQL. Also I can not change its settings because it's a shared hosting and I dont have access to it.
How can I force MySQL to run in case insensitive mode using a run time script in PHP?

Answer 1

Resolving this is actually very simple. All you need to do is edit the my.cnf file and set/add the following entry. For my default mysql install "my.cnf" was located at "c:\program files\mysql\mysql server[version]\my.cnf"

#Ensure that table names are stored case sensitive and that queries are case sensitive when naming a table
lower_case_table_names=0

you can change this path to gnu/linux