WampServer

Hi!
I install last wampserver (64x, Apache : 2.4.17 MySQL : 5.7.9 PHP : 5.6.16 PHP : 7) on Windows 7 64x, but MySQL server not starting with "lower_case_table_names = 0" in my.ini (after [mysqld]). MySQL logs is empty.
How fix it?

Without "lower_case_table_names = 0" or with "lower_case_table_names = 1" "lower_case_table_names = 2" it work correct



Edited 1 time(s). Last edit at 02/17/2016 02:01PM by guyasyou.

Hi,

Windows is not case sensitive and lower_case_table_names is absolutely worthless.
If you try to make MySQL on Windows "case sensitive", you run straight to disaster.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

If MYSQL does not start and no errors are present in the MYSQL ERROR LOG, then you should look at the Windows Event Viewer for errors produced by MYSQL

In this case you will see a message like this :-

Quote

The server option 'lower_case_table_names' is configured to use case sensitive table names but the data directory is on a case-insensitive file system which is an unsupported combination. Please consider either using a case sensitive file system for your data directory or switching to a case-insensitive table name mode.For more information, see Help and Support Center at [www.mysql.com].

As you can see from the message either this is not compatable or you have to change other things as well

See the Documentation [dev.mysql.com]


Remember it can cause compatibility issues if you get this decision wrong and intend to move databases between Windows and Unix system. If you dont then there seems little need to amend this param from its Windows default value of `lower_case_table_names = 1`

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-