Welcome Guest. Please Login or Register  


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



Threaded Mode | Print  

 lower_case_table_names problem, MySQL will not start on a new installation (1 Replies, Read 220 times)
jlarysz
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
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: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is July 9, 2020, 8:47 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.112