MySQL Forums
Forum List  »  InnoDB

Re: Change DB to case-insensitive = problems
Posted by: Scott Genevish
Date: October 15, 2014 01:17PM

I followed a slightly different tack:

- Rename the files back to what they were (not an easy feat as I didn't know how some of them had been capitalized).
- Put MySQL back into case-sensitive mode.
- Dump the databases with mysqldump, then drop them
- Change MySQL to case-insensitive (and restart)
- Re-import the databases from the dump files

Now MySQL will save the DB and tables with lowercase names, and will allow either case to be used in a query.

Thanks,

-Scott

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Change DB to case-insensitive = problems
1098
October 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.