MySQL Forums
Forum List  »  InnoDB

Case Sensitive file names on MacOS in innodb db
Posted by: Craig Adams
Date: August 29, 2017 03:03AM

For many years I have used innodb for my databases. My table naming convention has been camel case. I recently upgraded my Macbook and I now find that MySql cannot find any of my tables that are camel cased. I now have hundreds of tables, spanning dozens of databases, that are inaccessible .

MacOS: Sierra
MySql: 5.6.35

SHOW TABLES displays all tables as named in mixed case.
Directory listing in the file system shows all the files as named in mixed case.

SELECT * FROM myCamelCase --> displays error: Table 'mycamelcase' doesn't exist . (Note that the table name in the error is lower case.)

I tried renaming the files to all lower case in the file system. SHOW TABLES and the directory listing show the all lower case table/file names as expected. But a SELECT statement still yields the same error.

Options: ReplyQuote

Written By
Case Sensitive file names on MacOS in innodb db
August 29, 2017 03:03AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.