{"id":144,"date":"2016-06-08T23:17:29","date_gmt":"2016-06-08T14:17:29","guid":{"rendered":"https:\/\/www.itchefblog.com\/?p=144"},"modified":"2018-01-02T10:44:10","modified_gmt":"2018-01-02T01:44:10","slug":"mysqldump-%ec%9d%b4%ec%9a%a9-%ec%8b%9c-got-error-1016-%ec%97%90%eb%9f%ac-%eb%b0%9c%ec%83%9d-%ec%8b%9c-%eb%8c%80%ec%b2%98-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/www.itchefblog.com\/?p=144","title":{"rendered":"mysqldump \uc774\uc6a9 \uc2dc Got error: 1016 \uc5d0\ub7ec \ubc1c\uc0dd \uc2dc \ub300\ucc98 \ubc29\ubc95"},"content":{"rendered":"<p class=\"p1\">\uc11c\ubc84 \uc774\uc804 \uc791\uc5c5\uc744 \uc9c4\ud589\ud558\ub2e4\uac00 \ubc1c\uc0dd\ud55c \uc5d0\ub7ec\uc5d0 \uc57d\uac04 \ub2f9\ud669\ud588\uc9c0\ub9cc \ub2f9\ud669\ud558\uc9c0 \uc54a\uace0<span class=\"s1\">(?)\u00a0<\/span>\uac80\uc0c9\uc744 \ud1b5\ud574 \ud574\uacb0\ud55c \uac83\uc744 \ub0a8\uae30\uace0\uc790 \ud55c\ub2e4<span class=\"s1\">.<\/span><\/p>\n<p class=\"p1\">MySQL DB<span class=\"s2\">\ub97c<\/span>\u00a0(<span class=\"s2\">\uc815\ud655\ud788<\/span>\u00a0<span class=\"s2\">\ub9d0\ud558\uc790\uba74<\/span>\u00a0MariaDB&#8230;)\u00a0<span class=\"s2\">\ub364\ud504<\/span>\u00a0<span class=\"s2\">\ud574\uc11c<\/span>\u00a0<span class=\"s2\">\ub2e4\ub978<\/span>\u00a0<span class=\"s2\">\uc11c\ubc84\ub85c<\/span>\u00a0<span class=\"s2\">\uc62e\uaca8\uc57c<\/span>\u00a0<span class=\"s2\">\ud558\ub294<\/span>\u00a0<span class=\"s2\">\uc0c1\ud669\uc774<\/span>\u00a0<span class=\"s2\">\ubc1c\uc0dd<\/span>.<\/p>\n<p class=\"p1\">mysqldump<span class=\"s2\">\ub97c<\/span>\u00a0<span class=\"s2\">\uc368\uc11c<\/span>\u00a0<span class=\"s2\">\ub364\ud504<\/span>\u00a0<span class=\"s2\">\ud558\ub824\ub294\ub370<\/span>\u00a0<span class=\"s2\">\uc6ec\uac78<\/span>!<\/p>\n<p class=\"p1\">mysqldump: Got error: 1016: &#8220;Can&#8217;t open file: &#8216;.\/db_name\/table_name.frm&#8217; (errno: 24)&#8221; when using LOCK TABLES<\/p>\n<p class=\"p2\">\u00a0\uc704\uc640 \uac19\uc740 \uc5d0\ub7ec\uac00 \ub728\uba74\uc11c \uc9c4\ud589\uc774 \ub418\uc9c0 \uc54a\ub294 \uac83\uc774\ub2e4<span class=\"s1\">!<\/span><\/p>\n<p class=\"p2\">\uc774\ub7f4 \ub54c\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc635\uc158\uc744 \uc0ac\uc6a9\ud574 \uc8fc\uba74 \uac04\ub2e8\ud788 \ud574\uacb0\ub41c\ub2e4<span class=\"s1\">.<\/span><\/p>\n<p class=\"p2\">\u00a0mysqldump -u\u00a0<span class=\"s2\">\uc0ac\uc6a9\uc790\uba74<\/span>\u00a0-p\u00a0<span class=\"s2\">\ud328\uc2a4\uc6cc\ub4dc<\/span>\u00a0DB<span class=\"s2\">\uba85<\/span>\u00a0&#8211;lock-tables=false &gt;\u00a0<span class=\"s2\">\ub364\ud504\ud30c\uc77c\uba85<\/span>.sql<\/p>\n<p class=\"p2\">\u00a0&#8220;&#8211;lock-tables=false&#8221;<span class=\"s2\">\ub9cc<\/span>\u00a0<span class=\"s2\">\uae30\uc5b5\ud558\uc790<\/span>~<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc11c\ubc84 \uc774\uc804 \uc791\uc5c5\uc744 \uc9c4\ud589\ud558\ub2e4\uac00 \ubc1c\uc0dd\ud55c \uc5d0\ub7ec\uc5d0 \uc57d\uac04 \ub2f9\ud669\ud588\uc9c0\ub9cc \ub2f9\ud669\ud558\uc9c0 \uc54a\uace0(?)\u00a0\uac80\uc0c9\uc744 \ud1b5\ud574 \ud574\uacb0\ud55c \uac83\uc744 \ub0a8\uae30\uace0\uc790 \ud55c\ub2e4. MySQL DB\ub97c\u00a0(\uc815\ud655\ud788\u00a0\ub9d0\ud558\uc790\uba74\u00a0MariaDB&#8230;)\u00a0\ub364\ud504\u00a0\ud574\uc11c\u00a0\ub2e4\ub978\u00a0\uc11c\ubc84\ub85c\u00a0\uc62e\uaca8\uc57c\u00a0\ud558\ub294\u00a0\uc0c1\ud669\uc774\u00a0\ubc1c\uc0dd. mysqldump\ub97c\u00a0\uc368\uc11c\u00a0\ub364\ud504\u00a0\ud558\ub824\ub294\ub370\u00a0\uc6ec\uac78! mysqldump: Got error: 1016: &#8220;Can&#8217;t open file: &#8216;.\/db_name\/table_name.frm&#8217; (errno: 24)&#8221; when using LOCK TABLES \u00a0\uc704\uc640 \uac19\uc740 \uc5d0\ub7ec\uac00 \ub728\uba74\uc11c \uc9c4\ud589\uc774 \ub418\uc9c0 \uc54a\ub294 \uac83\uc774\ub2e4! \uc774\ub7f4 \ub54c\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc635\uc158\uc744 \uc0ac\uc6a9\ud574 \uc8fc\uba74 \uac04\ub2e8\ud788 \ud574\uacb0\ub41c\ub2e4. \u00a0mysqldump -u\u00a0\uc0ac\uc6a9\uc790\uba74\u00a0-p\u00a0\ud328\uc2a4\uc6cc\ub4dc\u00a0DB\uba85\u00a0&#8211;lock-tables=false &gt;\u00a0\ub364\ud504\ud30c\uc77c\uba85.sql \u00a0&#8220;&#8211;lock-tables=false&#8221;\ub9cc\u00a0\uae30\uc5b5\ud558\uc790~<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[38,39,40,41,42,43,44,45,46],"_links":{"self":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/144"}],"collection":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=144"}],"version-history":[{"count":2,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/144\/revisions"}],"predecessor-version":[{"id":154,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/144\/revisions\/154"}],"wp:attachment":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}