{"id":235,"date":"2016-10-26T16:27:48","date_gmt":"2016-10-26T07:27:48","guid":{"rendered":"http:\/\/jook.pe.kr\/?p=235"},"modified":"2016-10-26T16:27:48","modified_gmt":"2016-10-26T07:27:48","slug":"mysqlcheck-%ec%82%ac%ec%9a%a9%ed%95%b4%ec%84%9c-%ed%85%8c%ec%9d%b4%eb%b8%94-%eb%b3%b5%ea%b5%ac%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/jook.pe.kr\/?p=235","title":{"rendered":"mysqlcheck \uc0ac\uc6a9\ud574\uc11c \ud14c\uc774\ube14 \ubcf5\uad6c\ud558\uae30"},"content":{"rendered":"

mysqlcheck \uc0ac\uc6a9\ubc95<\/p>\n

 <\/p>\n

1. mysql \uc804\uccb4 DB \ubcf5\uad6c<\/p>\n

[root@localhost \/]# mysqlcheck -Aao –auto-repair -u root -p\ud328\uc2a4\uc6cc\ub4dc<\/p>\n

 <\/p>\n

2. mysql \uc9c0\uc815 DB \ubcf5\uad6c<\/p>\n

[root@localhost \/]# mysqlcheck –auto-repair -u root -p\ud328\uc2a4\uc6cc\ub4dc \u00a0DB\uba85<\/p>\n

 <\/p>\n

3. mysql \ud2b9\uc815 DB\uc758 \ud2b9\uc815\ud14c\uc774\ube14 \ubcf5\uad6c<\/p>\n

[root@localhost \/]# mysqlcheck –auto-repair -u root -p\ud328\uc2a4\uc6cc\ub4dc \u00a0DB\uba85 \ud14c\uc774\ube14\uba85<\/p>\n

 <\/p>\n

————————————————————–
\n\uc544\ub798\uc640 \uac19\uc774 mysql \uc811\uc18d\ud6c4 \ucffc\ub9ac\ubb38\uc73c\ub85c \uccb4\ud06c \ubc0f \ubcf5\uad6c\ub3c4 \uac00\ub2a5<\/p>\n

 <\/p>\n

[root@localhost \/]# mysql -u root -p\ud328\uc2a4\uc6cc\ub4dc<\/p>\n

 <\/p>\n

mysql> use DB\uba85;<\/p>\n

mysql> show tables;<\/p>\n

mysql> check table \ud14c\uc774\ube14\uba85;<\/p>\n

mysql> repair table \ud14c\uc774\ube14\uba85;<\/p>\n","protected":false},"excerpt":{"rendered":"

mysqlcheck \uc0ac\uc6a9\ubc95   1. mysql \uc804\uccb4 DB \ubcf5\uad6c [root@localhost \/]# mysqlcheck -Aao –auto-repair -u root -p\ud328\uc2a4\uc6cc\ub4dc   2. mysql \uc9c0\uc815<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,6],"tags":[],"_links":{"self":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts\/235"}],"collection":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=235"}],"version-history":[{"count":0,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts\/235\/revisions"}],"wp:attachment":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=235"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}