lower_case_table_names in Mamp Pro Windows

Permalink 1 user found helpful
Today I bought Mamp Pro 4.1.0 for Windows and install it and tried to install Concrete5. When using Mamp Pro I get the error message:
Table case: Table names are stored in the lowercase: you may have problems if you plan to move this installation to another server (hint: you should set the lower_case_table_names MySQL variable to 2)

I change the C:\Mamp\config\mysql\my.ini and add the line: lower_case_table_names=2
In Mamp Pro this didn't work, but when I use Mamp (not the Pro-version) it works well, so Mamp Pro use maybe another file: I search for this but couldn't find it. Why works this solution with Mamp and not wit Mamp Pro and how could I solve this error in Mamp Pro?

Many thanks,
Peter

View Replies: View Best Answer
JohntheFish replied on at Permalink Reply
JohntheFish
You may need to restart the MySQL service (or just reboot).
(I am not a Mac user)
Ishtar replied on at Permalink Reply
Thank you, but I already boot everything: Windows, Mamp, servers. In Mamp it works well, but not in Mamp Pro
Ishtar replied on at Permalink Best Answer Reply
I found that Mamp Pro in Windows works with files in C:\users\public\documents\Appsolute\MAMPPRO\conf
After adding the line: lower_case_table_names=2 in this my.ini it works also in Mams Pro
stewblack23 replied on at Permalink Reply
stewblack23
Thanks. I forgot all about this until I updated Mamp Pro today and uploaded a .sql file to phpmyadmin.