Tips & Tricks
Mysql Getting Random Row: “order by rand()”
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