MySQL linux table names ignore case considerations

Using Lower_case_tables_name=0 in Unix, use lower_case_tables_name=2 in Windows. This preserves the case of the database name and table name. The disadvantage is that you must ensure that queries in Windows always refer to the database name and table name with the correct case. If queries are transferred to UNIX, they do not work because of the importance of casing in Unix, if the casing is not correct.
Exception: If you are using the InnoDB table, you should set Lower_case_tables_name to 1 on any platform to force the name to lowercase.
Note Before you restart mysqld before you set Lower_case_tables_name to 1 in Unix, you must first convert the old database name and table name to lowercase

MySQL linux table names ignore case considerations