lower_case_table_names problem

You are here: Index > AMPPS > General Support > Topic : lower_case_table_names problem

lower_case_table_names problem, MySQL will not start on a new installation (1 Replies, Read 17793 times)

jlarysz	# May 15, 2020, 1:47 pm
Group: Member Post Group: Newbie Posts: 2 Status:	I've just installed AMPPS 3.9 on Windows 10 using the msi installer. MySQL will not start with the log message Different lower_case_table_names settings for server ('2') and data dictionary ('1') I have tried setting lower_case_table_names to '1' in my.ini, but then MySQL shuts itself down shortly after startup. I cannot find where to set the server value for lower_case_table_names. What is wrong here and how can I fix it?
IP: --

lower_case_table_names problem

xhtmlmagic	# June 18, 2020, 6:31 am \| Post: 1
Group: Member Post Group: Newbie Posts: 1 Status:	Even worse, I've upgraded from AMPPS 3.8 and have the same error. When I change to lower_case_table_names=1, Mysql works, but there are no existing databases, which wouldn't be a problem since I have them backed up, but when I try to import them, Mysql says no, they already exist. How to make Mysql see the databases or start it empty so I can import them?
IP: --

Jump To :

Users viewing this topic
	2 guests, 0 users.

All times are GMT. The time now is November 1, 2024, 12:33 am.

Queries: 10 | Page Created In:0.029