When transitioning MySQL database from Windows to Linux, users often encounter issues related to case-sensitiveness. Windows is case-insensitive and Linux is case-sensitive.

In such scenarios when a database call is made after the application migration happens, users often run into errors which can send them in circles between the migration servers.

Solution to this problem is to add a single line of text under my.cnf (MySQL configuration file) under [mysqld]

lower_case_table_names=1

$ whereis my.cnf
/etc/my.cnf

$ vi my.cnf
…
…
[mysqld]
lower_case_table_names=1

Common Errors related to this issue

When the application is executed, users get “table not found” errors which is an indication of this error. You can verify the error by issuing the command

$ mysqladmin -uAdmin -pPass variables

and check for the value of lower_case_table_names.