I am trying to restore a backup created in Ubuntu 20.04 LTS in Mac. However, while trying to restore I see the error:
2022-04-25T09:43:31.742658Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('2') and data dictionary ('0'). 2022-04-25T09:43:31.742830Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
How do I fix this? Thanks!
The error tells you what you need to do. You need to set
lower_case_table_names=0 so that the current server config matches the old config.
Thank you for your solution. But how do I set
lower_case_table_names to 0?
Is this your very first time using MySQL? All config options go into my.cnf. You need to locate this file for your OS and add the parameter.
Oh I see. I’ve been using sql for a long time. I just never heard of
lower_case_table_names . Anyway, thank you so much for your help.