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
View Replies:
Mainio replied on at Permalink Reply
Mainio
You might have modified the wrong configuration file.

Run this command with your MySQL client:
mysql --verbose --help


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:
mysql --verbose --help | grep -A 1 "Default options"


This will not work if you don't have cygwin or the "grep" program installed on your machine.

Antti / Mainio
mcc5 replied on at Permalink Reply
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!

concrete5 Environment Information

Browser User-Agent String

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You have not specified a license for this support ticket. You must have a valid license assigned to a support ticket to request a refund.