MySQL Forums :: InnoDB :: Change DB to case-insensitive = problems


Advanced Search

Change DB to case-insensitive = problems
Posted by: Scott Genevish ()
Date: October 14, 2014 03:54PM

I changed MySQLd running on Linux to be case-insensitive (lower_case_table_names=1). Then, queries were failing because MySQL looks for every table with a lowercase name. Easily solved, I thought. I renamed the database directories and table files with lower case names.

Now I get something like this for every table:

select * from dim_customer Error Code: 1146. Table 'reportingdatawarehouse.dim_customer' doesn't exist

My guess is that the ib_data or ib_logfile0 files have the old names referenced in them maybe? How do I fix this?

Thanks,

-Scott

Options: ReplyQuote


Subject Views Written By Posted
Change DB to case-insensitive = problems 1155 Scott Genevish 10/14/2014 03:54PM
Re: Change DB to case-insensitive = problems 598 Rick James 10/15/2014 11:55AM
Re: Change DB to case-insensitive = problems 691 Scott Genevish 10/15/2014 01:17PM


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.