{"id":1874,"date":"2022-12-03T12:26:46","date_gmt":"2022-12-03T03:26:46","guid":{"rendered":"https:\/\/ani2life.com\/wp\/?p=1874"},"modified":"2022-12-03T12:26:46","modified_gmt":"2022-12-03T03:26:46","slug":"macos-%eb%8f%84%ec%bb%a4-%eb%8d%b0%ec%8a%a4%ed%81%ac%ed%83%91%ec%97%90%ec%84%9c-mysql-%ec%82%ac%ec%9a%a9-%ec%8b%9c-different-lower_case_table_names-%eb%ac%b8%ec%a0%9c-%ed%95%b4%ea%b2%b0-%eb%b0%a9","status":"publish","type":"post","link":"https:\/\/ani2life.com\/wp\/?p=1874","title":{"rendered":"macOS \ub3c4\ucee4 \ub370\uc2a4\ud06c\ud0d1\uc5d0\uc11c MySQL \uc0ac\uc6a9 \uc2dc Different lower_case_table_names \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95"},"content":{"rendered":"<p>macOS\uc5d0\uc11c \ub3c4\ucee4 \ub370\uc2a4\ud06c\ud0d1 \uc0ac\uc6a9 \uc2dc \uc131\ub2a5\uc774 \ub5a8\uc5b4\uc9c0\ub294 \uac00\uc7a5 \ud070 \uc6d0\uc778\uc740 \ub514\uc2a4\ud06c I\/O \uc774\ub2e4.<\/p>\n<p>\uc774\uc5d0 \ub3c4\ucee4 \ub370\uc2a4\ud06c\ud0d1\uc5d0\uc11c \uac1c\uc120\ub41c \ud30c\uc77c \uacf5\uc720 \ubc29\uc2dd\uc73c\ub85c VirtioFS \uc120\ud0dd\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n<p><a href=\"https:\/\/ani2life.com\/wp\/wp-content\/uploads\/2022\/12\/Docker-Desktop-Choose-file-sharing-implementation.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1875 size-large\" src=\"https:\/\/ani2life.com\/wp\/wp-content\/uploads\/2022\/12\/Docker-Desktop-Choose-file-sharing-implementation-1024x162.png\" alt=\"Docker Desktop Choose file sharing implementation\" width=\"625\" height=\"99\" srcset=\"https:\/\/ani2life.com\/wp\/wp-content\/uploads\/2022\/12\/Docker-Desktop-Choose-file-sharing-implementation-1024x162.png 1024w, https:\/\/ani2life.com\/wp\/wp-content\/uploads\/2022\/12\/Docker-Desktop-Choose-file-sharing-implementation-300x48.png 300w, https:\/\/ani2life.com\/wp\/wp-content\/uploads\/2022\/12\/Docker-Desktop-Choose-file-sharing-implementation-768x122.png 768w, https:\/\/ani2life.com\/wp\/wp-content\/uploads\/2022\/12\/Docker-Desktop-Choose-file-sharing-implementation-624x99.png 624w, https:\/\/ani2life.com\/wp\/wp-content\/uploads\/2022\/12\/Docker-Desktop-Choose-file-sharing-implementation.png 1350w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/a><\/p>\n<p>\uadf8\ub7f0\ub370 \ub9cc\uc57d \ub9ac\ub205\uc2a4\uc5d0\uc11c \uac00\uc838\uc628 MySQL data \ud30c\uc77c\ub4e4\uc744 \uac00\uc9c0\uace0 macOS\uc5d0\uc11c \ub3c4\ucee4 \ucee8\ud14c\uc774\ub108\ub85c \ub744\uc6b0\ub294 \uacbd\uc6b0 \ud30c\uc77c \uacf5\uc720 \ubc29\uc2dd\uc73c\ub85c VirtioFS \ub610\ub294 gRPC FUSE \uc120\ud0dd \uc2dc MySQL \ucee8\ud14c\uc774\ub108 \ub85c\uadf8\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc624\ub958\ub97c \ub744\uc6b0\uba70 \uc2e4\ud589\uc774 \uc548\ub420 \uc218 \uc788\ub2e4.<\/p>\n<p><code class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\">Different lower_case_table_names settings for server ('2') and data dictionary ('0')<\/code><\/p>\n<p>\uba3c\uc800 MySQL\uc758 <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/server-system-variables.html#sysvar_lower_case_table_names\" target=\"_blank\" rel=\"noopener\">lower_case_table_names<\/a> \uc2dc\uc2a4\ud15c \ubcc0\uc218\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n<ul>\n<li>0 : \ud14c\uc774\ube14 \uc774\ub984\uc774 \uc9c0\uc815\ub41c \ub300\ub85c \uc800\uc7a5\ub418\uace0 \ube44\uad50\ub294 \ub300\/\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud569\ub2c8\ub2e4.<\/li>\n<li>1 : \ud14c\uc774\ube14 \uc774\ub984\uc774 \ub514\uc2a4\ud06c\uc5d0 \uc18c\ubb38\uc790\ub85c \uc800\uc7a5\ub418\uba70 \ube44\uad50\ub294 \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud569\ub2c8\ub2e4.<\/li>\n<li>2 : \ud14c\uc774\ube14 \uc774\ub984\uc774 \uc8fc\uc5b4\uc9c4 \ub300\ub85c \uc800\uc7a5\ub429\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc18c\ubb38\uc790\ub85c \ube44\uad50\ub429\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>lower_case_table_names \uc124\uc815\uc740 \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\ub294 \ub514\uc2a4\ud06c \ud3ec\ub9f7\uc778\uc9c0 \uc5ec\ubd80\uac00 \uc911\uc694\ud55c\ub370 macOS\uc758 \uae30\ubcf8 \ub514\uc2a4\ud06c \ud3ec\ub9f7\uc740 \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\uc9c0 \uc54a\uc73c\ubbc0\ub85c \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\ub294 lower_case_table_names = 0 \uc124\uc815\uc73c\ub85c \ub9cc\ub4e4\uc5b4\uc9c4 MySQL \ub370\uc774\ud130 \ud30c\uc77c\uc744 \uc4f8 \uc218 \uc5c6\ub2e4.<\/p>\n<p>\uc774 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub294 \ubc29\ubc95\uc911 \ud558\ub098\ub294 MySQL data \ud30c\uc77c\uc744 \uadf8\ub300\ub85c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uace0 mysqldump\ub85c \ub370\uc774\ud130\ub97c \ub0b4\ubcf4\ub0b8 \ud6c4 macOS\uc758 MySQL \ub3c4\ucee4 \ucee8\ud14c\uc774\ub108\uc5d0\uc11c \ubcf5\uad6c\ud558\uba74 \ub418\ub294\ub370 \ub108\ubb34\ub098 \ube44\ud6a8\uc728\uc801\uc778 \ubc29\ubc95\uc774\ub2e4.<\/p>\n<p>\ub0b4\uac00 \ucd94\ucc9c\ud558\ub294 \uac00\uc7a5 \ud3b8\ub9ac\ud55c \ubc29\ubc95\uc740 \ub300\uc18c\ubb38\uc790 \uad6c\ubd84\uc774 \uac00\ub2a5\ud55c \ub514\uc2a4\ud06c \ud3ec\ub9f7\uc73c\ub85c \ub41c \ubcfc\ub968\uc744 \ucd94\uac00\ud558\ub294 \uac83\uc774\ub2e4. macOS\uc758 \ub514\uc2a4\ud06c \uc720\ud2f8\ub9ac\ud2f0\uc5d0\uc11c \uc27d\uac8c \ubcfc\ub968\uc744 \ucd94\uac00\ud560 \uc218 \uc788\ub2e4. \uc774\ub54c \ub514\uc2a4\ud06c \ud3ec\ub9f7 \ubc29\uc2dd\uc73c\ub85c <strong>APFS(\ub300\uc18c\ubb38\uc790 \uad6c\ubd84)<\/strong>\uc744 \uc120\ud0dd\ud558\uba74 \ub41c\ub2e4.<\/p>\n<p><a href=\"https:\/\/ani2life.com\/wp\/wp-content\/uploads\/2022\/12\/macOS-Disk-Utility-Add-a-Volume.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1876 size-large\" src=\"https:\/\/ani2life.com\/wp\/wp-content\/uploads\/2022\/12\/macOS-Disk-Utility-Add-a-Volume-1024x530.jpg\" alt=\"macOS Disk Utility Add a Volume\" width=\"625\" height=\"323\" srcset=\"https:\/\/ani2life.com\/wp\/wp-content\/uploads\/2022\/12\/macOS-Disk-Utility-Add-a-Volume-1024x530.jpg 1024w, https:\/\/ani2life.com\/wp\/wp-content\/uploads\/2022\/12\/macOS-Disk-Utility-Add-a-Volume-300x155.jpg 300w, https:\/\/ani2life.com\/wp\/wp-content\/uploads\/2022\/12\/macOS-Disk-Utility-Add-a-Volume-768x398.jpg 768w, https:\/\/ani2life.com\/wp\/wp-content\/uploads\/2022\/12\/macOS-Disk-Utility-Add-a-Volume-624x323.jpg 624w, https:\/\/ani2life.com\/wp\/wp-content\/uploads\/2022\/12\/macOS-Disk-Utility-Add-a-Volume.jpg 1228w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/a><\/p>\n<p>\uc774\ub807\uac8c \uc0c8\ub85c \ucd94\uac00\ud55c \ub300\uc18c\ubb38\uc790 \uad6c\ubd84 \uac00\ub2a5\ud55c \ubcfc\ub968\uc5d0 MySQL data \ud30c\uc77c\uc744 \ub123\uace0 MySQL \ub3c4\ucee4 \ucee8\ud14c\uc774\ub108\ub97c \uc2e4\ud589\ud558\uba74 \ubb38\uc81c\uc5c6\uc774 \uc2e4\ud589\ub41c\ub2e4.<\/p>\n<p>\uc55e\uc73c\ub85c \uac1c\ubc1c \ud504\ub85c\uc81d\ud2b8 \ud30c\uc77c\uc740 \ub300\uc18c\ubb38\uc790 \uad6c\ubd84 \uac00\ub2a5\ud55c \ubcfc\ub968\uc5d0\uc11c \ud558\uac70\ub098 \ub610\ub294 \ub300\uc18c\ubb38\uc790 \uad6c\ubd84\uc774 \ud544\uc694\ud55c MySQL data \uac19\uc740 \ud30c\uc77c\ub9cc \ub123\uc5b4\uc11c \uc4f0\uae30 \ud3b8\ud55c \uc704\uce58\uc5d0 \uc2ec\ubcfc\ub9ad \ub9c1\ud06c\ub97c \uac78\uc5b4\uc11c \uc0ac\uc6a9\ud558\ub294 \ubc29\uc2dd\ub3c4 \ucd94\ucc9c\ud55c\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>macOS\uc5d0\uc11c \ub3c4\ucee4 \ub370\uc2a4\ud06c\ud0d1 \uc0ac\uc6a9 \uc2dc \uc131\ub2a5\uc774 \ub5a8\uc5b4\uc9c0\ub294 \uac00\uc7a5 \ud070 \uc6d0\uc778\uc740 \ub514\uc2a4\ud06c I\/O \uc774\ub2e4. \uc774\uc5d0 \ub3c4\ucee4 \ub370\uc2a4\ud06c\ud0d1\uc5d0\uc11c \uac1c\uc120\ub41c \ud30c\uc77c \uacf5\uc720 \ubc29\uc2dd\uc73c\ub85c VirtioFS \uc120\ud0dd\uc774 \uac00\ub2a5\ud558\ub2e4. \uadf8\ub7f0\ub370 \ub9cc\uc57d \ub9ac\ub205\uc2a4\uc5d0\uc11c \uac00\uc838\uc628 MySQL data \ud30c\uc77c\ub4e4\uc744 \uac00\uc9c0\uace0 macOS\uc5d0\uc11c \ub3c4\ucee4 \ucee8\ud14c\uc774\ub108\ub85c \ub744\uc6b0\ub294 \uacbd\uc6b0 \ud30c\uc77c \uacf5\uc720 \ubc29\uc2dd\uc73c\ub85c VirtioFS \ub610\ub294 gRPC FUSE \uc120\ud0dd \uc2dc MySQL \ucee8\ud14c\uc774\ub108 \ub85c\uadf8\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc624\ub958\ub97c \ub744\uc6b0\uba70 \uc2e4\ud589\uc774 \uc548\ub420 \uc218 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8,7],"tags":[555,255,556],"_links":{"self":[{"href":"https:\/\/ani2life.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1874"}],"collection":[{"href":"https:\/\/ani2life.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ani2life.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ani2life.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ani2life.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1874"}],"version-history":[{"count":1,"href":"https:\/\/ani2life.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1874\/revisions"}],"predecessor-version":[{"id":1877,"href":"https:\/\/ani2life.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1874\/revisions\/1877"}],"wp:attachment":[{"href":"https:\/\/ani2life.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ani2life.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ani2life.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}