my.ini line added but add-on still says db in lower case mode
Permalink Browser Info Environment
I added the lower_case_table_names=0 to my.ini and restarted the database server but in the Database Migration panel I still see "Your database is set to lower case mode and running this script automatically will not work!" Why is this? I tried uninstalling and reinstalling the add-on. This is in Windows with Bitnami.
Type: | Discussion |
---|---|
Status: | New |
Ok, it's fixed. I ran that command and it said lower_case_table_names was an unknown variable. Some searching led me to conclude that I had placed the lower_case_table_names line in the wrong part of my.ini. I put it under [mysqld] and the warning in Database Migration went away. I was able to do the database migration. I recommend adding this to the documentation.
Thank you!
Thank you!
Run this command with your MySQL client:
On the line where it states "Default options are read from the following files in the given order:", you'll see which config files are loaded by default. And please also note that if the directive is overridden in one of the latter files, that will always override the previously set configuration for the same directive.
If you have cygwin installed, you can also grep the output to find that spot easier:
This will not work if you don't have cygwin or the "grep" program installed on your machine.
Antti / Mainio