Bug #467 Table names appear in lower case from mysqldump on Mac OS X
Submitted: 21 May 2003 0:25 Modified: 21 May 2003 8:37
Reporter: John Pollard Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S2 (Serious)
Version:4.0.12 OS:MacOS (Mac OS X)
Assigned to: CPU Architecture:Any

[21 May 2003 0:25] John Pollard 
Description:
When dumping a (innodb) database using for example:

mysqldump -uroot -hmyhost MYDB

on Mac OS X, all table names in the dump come out as lower case when they have been 
defined as mixed case (and mysql commands require the case to be exact or they fail).

This problem didn't exist on version 4.0.4 which is the last version I had before 4.0.12. for 
that version the dumps would come out mixed case if that is how they are on the 
database.

How to repeat:
Create a database with a table MyTable and then use mysqldump to dump the database 
and you will see it referred to as mytable.

Suggested fix:
The dump should produce the same mixed case table names as are defined on the 
database.
[21 May 2003 8:37] Indrek Siitan 
This has been changed in 4.0.6, from where on the Mac OS binaries are now compiled with --
lower-case-table-names on. This is documented in the ChangeLog at: http://www.mysql.com/
doc/en/News-4.0.6.html

The reason for this (as described in http://www.mysql.com/doc/en/Name_case_sensitivity.html) is 
that one of the possible file systems on Mac OS X (namely, HFS+) is not case sensitive, and would 
cause problems since for example Aa and aA would be considered the same table by the file 
system, but not by MySQL.

If you have the UFS filesystem and would like to revert this behaviour, you can add the following 
line to your my.cnf file in the [mysqld] section:

lower_case_table_names=off