As the title suggests, this is about mysql on case sensitive filesystem on *nix  Systems.

Situation is I had all my application written with SQL having uppercase table names.

But the mysql on linux had all in lowercase.

Quick Fix is to tell mysqlserver not to compare case while looking up table names

Edit /etc/my.cnf and add following setting.

[mysqld]

lower_case_table_names=1

Save File and Restart Mysql

Cross check variable value as follows

#mysqladmin variables

Done