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
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
Thank you, but I already boot everything: Windows, Mamp, servers. In Mamp it works well, but not in Mamp Pro
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
After adding the line: lower_case_table_names=2 in this my.ini it works also in Mams Pro
Thanks. I forgot all about this until I updated Mamp Pro today and uploaded a .sql file to phpmyadmin.
(I am not a Mac user)