Re: Change DB to case-insensitive = problems
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
Subject
Views
Written By
Posted
2075
October 14, 2014 03:54PM
1074
October 15, 2014 11:55AM
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.