WampServer

Hi!

I'm trying to get 'lower_case_table_names = 2' working on a *new* Wampserver installation by editing the my.ini of the respective Mysql version.

There is no existing user database present but unfortunately Wampserver will not start the service wampmysqld64.

I'm aware that it isn't good etiquette to use uppercase in db tables, but the clients database has this sturcture and I can't influence that.

Thanks for any suggestions!



Edited 1 time(s). Last edit at 03/07/2025 10:59PM by Xavier Bit.

Hi,

I highly doubt this will work on Windows, which is case-insensitive.
See the documentation MySQL identifier case sensivity <- This is a link

This produces an error in MySQL logs:

[ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('2') and data dictionary ('1').
[ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
[ERROR] [MY-010119] [Server] Aborting

See the documentation MySQL data distionnary schema <- This is a link

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

Hi Otomatic!
Thanks for your reply. I gave up on this idea and ended up batch replacing all the table names and got it working on Linux.