Linux: Case sensitive MySQL table names

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] (more…)