# How to restore linux backup in mac?

**URL:** <https://forums.percona.com/t/how-to-restore-linux-backup-in-mac/15381>\
**Category:** MySQL & MariaDB\
**Tags:** mysql, percona\
**Created:** [April 25, 2022, 9:44am UTC](https://forums.percona.com/t/how-to-restore-linux-backup-in-mac/15381 "2022-04-25T09:44:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![axel](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/axel/32/10423_2.png) [@axel](https://forums.percona.com/u/axel)\
**Post date:** [April 25, 2022, 9:44am UTC](https://forums.percona.com/t/how-to-restore-linux-backup-in-mac/15381/1 "2022-04-25T09:44:18Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [April 25, 2022, 3:11pm UTC](https://forums.percona.com/t/how-to-restore-linux-backup-in-mac/15381/2 "2022-04-25T15:11:02Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![axel](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/axel/32/10423_2.png) [@axel](https://forums.percona.com/u/axel)\
**Post date:** [April 27, 2022, 2:18pm UTC](https://forums.percona.com/t/how-to-restore-linux-backup-in-mac/15381/3 "2022-04-27T14:18:34Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [April 27, 2022, 3:16pm UTC](https://forums.percona.com/t/how-to-restore-linux-backup-in-mac/15381/4 "2022-04-27T15:16:07Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![axel](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/axel/32/10423_2.png) [@axel](https://forums.percona.com/u/axel)\
**Post date:** [April 29, 2022, 6:32am UTC](https://forums.percona.com/t/how-to-restore-linux-backup-in-mac/15381/5 "2022-04-29T06:32:00Z")

</div>

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.