Bug #36013 lower_case_table_names + problem

• Submitted: 12 Apr 2008 5:28
• Modified: 12 Apr 2008 9:16
• Reporter: nilesh paladiya
• Status: Not a Bug
• Category: MySQL Server: Charsets
• Severity: S3 (Non-critical)
• Version: 5.0.27
• OS: Linux
• CPU Architecture: Any
• Tags: Not able to set variables lower_case_table_names to 2

[12 Apr 2008 5:28] nilesh paladiya

Description:
[Warning] lower_case_table_names was set to 2, even though your the file system '/var/lib/mysql/' is case sensitive.  Now setting lower_case_table_names to 0 to avoid future problems.

How to repeat:
[Warning] lower_case_table_names was set to 2, even though your the file system '/var/lib/mysql/' is case sensitive.  Now setting lower_case_table_names to 0 to avoid future problems.

[12 Apr 2008 5:32] nilesh paladiya

When I try to start mysql, I am getting below log.
[Warning] lower_case_table_names was set to 2, even though your the file system '/var/lib/mysql/' is case sensitive.  Now setting lower_case_table_names to 0 to avoid future problems.

I am not able to set lower_case_table_names to 2 in Fedora6. I have set variable in /etc/my.cnf file.

My all database tables has storage engine MyISAM.

Could you please help to get rid of this.

Thanks.

[12 Apr 2008 9:16] Valeriy Kravchuk

Please, read the manual, http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html:

"Table and database names are stored on disk using the lettercase specified in the CREATE TABLE or CREATE DATABASE statement, but MySQL converts them to lowercase on lookup. Name comparisons are not case sensitive. This works only on filesystems that are not case sensitive!"