MySQL Case Sensitivity on Windows

From Birnam Designs Wiki

Jump to: navigation, search

When exporting a MySQL database on a Windows machine to be used on a Linux system, all table names are lowercase by default -- causing problems on the Linux system!

Fix: open your my.ini file, usually found in C:\Program Files\MySQL\MySQL Server X.x, and add:

lower_case_table_names=0

Restart the MySQL service before continuing.

Share This!
This page was last modified on 11 February 2010, at 19:45. This page has been accessed 305 times.