{"id":642,"date":"2013-06-12T15:30:40","date_gmt":"2013-06-12T06:30:40","guid":{"rendered":"http:\/\/www.freesens.com\/x\/?p=642"},"modified":"2013-06-12T15:31:41","modified_gmt":"2013-06-12T06:31:41","slug":"mysql-table%ec%9d%b4-%ea%b9%a8%ec%a1%8c%ec%9d%84%eb%95%8c-%eb%b3%b5%ea%b5%ac","status":"publish","type":"post","link":"http:\/\/www.freesens.com\/x\/?p=642","title":{"rendered":"mysql table\uc774 \uae68\uc84c\uc744\ub54c \ubcf5\uad6c.."},"content":{"rendered":"
\n

mysql\uc744 \uc368\ubcf4\uae34 \ud588\uc5b4\ub3c4 \ud14c\uc774\ube14\uc774 \uae68\uc9c4\uc801\uc740 \uc5c6\uc5c8\ub294\ub370………
\n\ubb3c\ub860 \uc774\ubc88\uc5d0\ub3c4 \ub0b4\uac00 \uc4f0\ub294\ub370\uc11c \ubb38\uc81c\uac00 \ub41c\uac74 \uc544\ub2c8\uace0.. \uc544\ub294 \ub3d9\uc0dd\uc774 \ubb3c\uc5b4\ubd10\uc11c…\uac80\uc0c9\uc744 \ud574\ubd24\ub294\ub370….\uc544\ub798\uc640 \uac19\uc740 \ubc29\ubc95\uc73c\ub85c \ud574\uacb0\uc774 \uac00\ub2a5\ud558\ub2e4\uace0 \ud558\ub294\ub370……..
\n\ub9c9\uc0c1 \ud574\ubcf4\ub2c8 repair \uba85\ub839\uc744 \uc2e4\ud589\ud558\uba74….syntax\uac00 \uc62c\ubc14\ub974\uc9c0 \uc54a\ub294\ub2e4\ub294 \ud5db\uc18c\ub9ac\ub9cc \uc9c0\uaec4\uc774\uace0…
\n\uacb0\uad6d myisamchk\ub85c \ud574\uacb0…..\uacb0\ub860\uc740 \uc544\ub798\uc640 \uac19\uc774…..;;;;<\/p>\n

%mysql inst dir%bin\/myisamchk -r %mysql data path%\/table_name<\/span><\/strong><\/p>\n

 <\/p>\n

[\ucd9c\ucc98]<\/strong>\u00a0[MySQL Error]Table ‘problem_table’ is marked as crashed and should be repaired.<\/a>|\uc791\uc131\uc790<\/strong>\u00a0NaNNa<\/a><\/p>\n

<\/div>\n<\/div>\n

###\u00a0\uc624\ub958 \uba54\uc138\uc9c0\u00a0###
\nGeneral SQL error.
\n[MySQL][ODBC 3.51 Driver][mysqld-5.0.21-community-nt]Table ‘problem_table’ is marked as crashed and should be repaired.<\/p>\n

 <\/p>\n

###\u00a0\uc6d0 \uc778 ###
\n\ud14c\uc774\ube14\uc774 \uc190\uc0c1\ub418\ub294 \uc99d\uc0c1\uc740 \uc544\ub798\uc640 \uac19\uc740 \uc608\uae30\uce58 \uc54a\ub294 \ubb38\uc81c\ub85c \uc778\ud558\uc5ec \ubc1c\uc0dd\ub429\ub2c8\ub2e4.
\n– tbl_name.frm\ubcc0\uacbd\uc5d0 \ub300\ud55c \ub77d\uc774 \uac78\ub9b0 \uacbd\uc6b0
\n– tbl_name.MYI(Errcode: nnn) \ud30c\uc77c\uc744 \ucc3e\uc744 \uc218 \uc5c6\ub294 \uacbd\uc6b0
\n– \uc608\uc0c1\uce58 \ubabb\ud55c \ud30c\uc77c \uc885\ub8cc
\n– \uc800\uc7a5 \ud30c\uc77c\uc758 \ucda9\ub3cc
\n– table handler\ub85c \ubd80\ud130 \uc624\ub958 nnn\uc744 \ubc1b\uc558\uc744 \ub54c<\/p>\n

\uc790\uc138\ud55c \ub0b4\uc6a9\uc740\u00a0MySQL 5.1 Reference Manual > 6.6.3 How to Repair MyISAM Tables<\/a>\u00a0\ub97c \ucc38\uc870\ubc14\ub78d\ub2c8\ub2e4.<\/p>\n

 <\/p>\n

### \ud574\uacb0 \ubc29\ubc95 ###
\n1. MySQL Query Browser \ub97c \uc774\uc6a9\ud558\uc5ec
\n1) \uc2dc\uc791>\ud504\ub85c\uadf8\ub7a8>MySQL>MySQL Query Browser\ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/p>\n

2) MySQL Query Brower \ub85c\uadf8\uc778 \ud654\uba74\uc5d0\uc11c \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud558\uace0
\n\ub85c\uadf8\uc778\ud569\ub2c8\ub2e4.<\/p>\n

3) MySQL Brower \uba54\ub274\uc758
\n“File>New Script Tab”\uc744 \uc2e4\ud589\ud558\uc5ec
\n\ub2e4\uc74c\uc744 \uc785\ub825<\/p>\n

analyze table problem_table;\/\/\ud574\ub2f9 \ud14c\uc774\ube14\uc758 \ubcf4\uace0\uc11c \uc791\uc131
\nrepair table problem_table;\/\/\ud574\ub2f9 \ud14c\uc774\ube14\uc758 \ubcf5\uc6d0 \uba85\ub839<\/p>\n

 <\/p>\n

4) MySQL Query Brower \uc624\ub978\ucabd \uc0c1\ub2e8\uc758 “Execute” \ubc84\ud2bc\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<\/p>\n

 <\/p>\n

2. MySQL Command Line Client\ub97c \uc774\uc6a9\ud558\uc5ec
\n1) \uc2dc\uc791>\ud504\ub85c\uadf8\ub7a8>MySQL>MySQL Sever>MySQL Command Line Client\ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/p>\n

2) \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud558\uc5ec MySQL Command Line\uc744 \uc2e4\ud589<\/p>\n

3) mysql>use db\uba85;\/\/\ud574\ub2f9 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc120\ud0dd
\nmysql>analyze table problem_table;\/\/\ud574\ub2f9 \ud14c\uc774\ube14\uc758 \ubcf4\uace0\uc11c \uc791\uc131
\nmysql>repair table problem_table;\/\/\ud574\ub2f9 \ud14c\uc774\ube14\uc758 \ubcf5\uc6d0 \uba85\ub839<\/p>\n

 <\/p>\n

\uc704\uc640 \uac19\uc740 \ubc29\ubc95\uc73c\ub85c \ud574\uacb0\uc774 \ub418\uc9c0 \uc54a\ub294 \ub2e4\uba74
\nMySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ube44\uc2a4\ub97c \uc911\uc9c0\uc2dc\ud0a4\uace0
\nC:\\Program Files\\MySQL\\MySQL Server\\bin \ud3f4\ub354\uc758 myisamchk.exe \uc2e4\ud589 \ud30c\uc77c\uc744 \uc774\uc6a9\ud558\uc5ec
\nmyisamchk -r problem_table; \uba85\ub839\uc73c\ub85c \ubcf5\uad6c \uc2dc\ub3c4\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n

\n

 <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

mysql\uc744 \uc368\ubcf4\uae34 \ud588\uc5b4\ub3c4 \ud14c\uc774\ube14\uc774 \uae68\uc9c4\uc801\uc740 \uc5c6\uc5c8\ub294\ub370……… \ubb3c\ub860 \uc774\ubc88\uc5d0\ub3c4 \ub0b4\uac00 \uc4f0\ub294\ub370\uc11c \ubb38\uc81c\uac00 \ub41c\uac74 \uc544\ub2c8\uace0.. \uc544\ub294 \ub3d9\uc0dd\uc774 \ubb3c\uc5b4\ubd10\uc11c…\uac80\uc0c9\uc744 \ud574\ubd24\ub294\ub370….\uc544\ub798\uc640 \uac19\uc740 \ubc29\ubc95\uc73c\ub85c \ud574\uacb0\uc774 \uac00\ub2a5\ud558\ub2e4\uace0 \ud558\ub294\ub370…….. \ub9c9\uc0c1 \ud574\ubcf4\ub2c8 repair \uba85\ub839\uc744 \uc2e4\ud589\ud558\uba74….syntax\uac00 \uc62c\ubc14\ub974\uc9c0 \uc54a\ub294\ub2e4\ub294 \ud5db\uc18c\ub9ac\ub9cc \uc9c0\uaec4\uc774\uace0… \uacb0\uad6d myisamchk\ub85c \ud574\uacb0…..\uacb0\ub860\uc740 \uc544\ub798\uc640 \uac19\uc774…..;;;; %mysql inst dir%bin\/myisamchk -r %mysql data path%\/table_name   [\ucd9c\ucc98]\u00a0[MySQL Error]Table ‘problem_table’ is marked as crashed and should be repaired.|\uc791\uc131\uc790\u00a0NaNNa … Continue reading mysql table\uc774 \uae68\uc84c\uc744\ub54c \ubcf5\uad6c..<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[204,140,141,205,203],"class_list":["post-642","post","type-post","status-publish","format-standard","hentry","category-etc","tag-crack","tag-dbms","tag-mysql","tag-table","tag-table-crack"],"_links":{"self":[{"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/posts\/642","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=642"}],"version-history":[{"count":2,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/posts\/642\/revisions"}],"predecessor-version":[{"id":644,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/posts\/642\/revisions\/644"}],"wp:attachment":[{"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=642"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}