How to restore linux backup in mac?

MySQL & MariaDB
,
1

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!

2

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.

1 Like
3

Thank you for your solution. But how do I set lower_case_table_names to 0?

1 Like
4

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.

1 Like
5

Oh I see. I’ve been using sql for a long time. I just never heard of lower_case_table_names :sweat_smile:. Anyway, thank you so much for your help.

1 Like