{"id":500,"date":"2007-04-14T23:53:55","date_gmt":"2007-04-14T14:53:55","guid":{"rendered":"http:\/\/pecos.myhome.cx\/wordpress\/?p=500"},"modified":"2007-04-14T23:53:55","modified_gmt":"2007-04-14T14:53:55","slug":"mysql%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e7%a0%b4%e6%90%8d","status":"publish","type":"post","link":"https:\/\/pecos.ddns.net\/wordpress\/?p=500","title":{"rendered":"MySQL\u30c6\u30fc\u30d6\u30eb\u7834\u640d"},"content":{"rendered":"

MT\u306e\u7ba1\u7406\u753b\u9762\u306b\u30ed\u30b0\u30a4\u30f3\u3059\u308b\u3068\u30c8\u30e9\u30c3\u30af\u30d0\u30c3\u30af\u4e00\u89a7\u304c\u6d88\u3048\u3066\u3044\u308b\u30fb\u30fb\u30fb
\n\u306f\u3066\uff1f\u4f55\u4e8b\u3068\u601d\u3044\/var\/lib\/mysql\u306e\u4e0b\u3092\u898b\u3066\u307f\u308b\u3068\u30a8\u30e9\u30fc\u30ed\u30b0\u306b<\/p>\n

070414 23:07:10 [ERROR] \/usr\/sbin\/mysqld: Table ‘.\/mt\/mt_tbping’ is marked as crashed and should be repaired<\/p><\/blockquote>\n

\u306a\u3093\u3066\u30a8\u30e9\u30fc\u304c\u305e\u308d\u305e\u308d\u4e26\u3093\u3067\u3044\u308b\u30fb\u30fb\u30fborz \u3067\u3001\u3053\u3093\u306a\u98a8\u306b\u4fee\u7e55\u3057\u3066\u307f\u3043<\/a>\u3068\u3042\u3063\u305f\u306e\u3067\u3001\u65e9\u901fMT\u7528\u306eDB\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u3084\u3063\u3066\u307f\u308b
\n
\n\u4f5c\u696d\u624b\u9806<\/p>\n

# mysql -u <UserName> -p <DatabseName>
\nmysql> CHECK TABLE mt_tbping MEDIUM;<\/strong>
\n+————–+——-+———-+——————————————————————–+
\n| Table | Op | Msg_type | Msg_text |
\n+————–+——-+———-+——————————————————————–+
\n| mt.mt_tbping | check | error | Table ‘.\/mt\/mt_tbping’ is marked as crashed and should be repaired |
\n+————–+——-+———-+——————————————————————–+
\n1 row in set (0.00 sec)<\/p><\/blockquote>\n

\u78ba\u304b\u306b\u58ca\u308c\u3066\u308b\u3063\u307d\u3044\u30fb\u30fb\u30fb<\/p>\n

mysql> REPAIR TABLE mt_tbping USE_FRM;<\/strong>
\n\u3000\u3000\uff1a
\n\u3000\u3000\uff1a
\nmysql> CHECK TABLE mt_tbping MEDIUM;<\/strong>
\n+————–+——-+———-+———-+
\n| Table | Op | Msg_type | Msg_text |
\n+————–+——-+———-+———-+
\n| mt.mt_tbping | check | status | OK |
\n+————–+——-+———-+———-+
\n1 row in set (0.06 sec)<\/p><\/blockquote>\n

\u76f4\u3063\u305f\uff1f\uff1f\u3082\u3046\u4e00\u5ea6MT\u306e\u7ba1\u7406\u753b\u9762\u3067\u898b\u3066\u307f\u308b\u3068\u5fa9\u6d3b\u3057\u305f\u306e\u3067\u76f4\u3063\u305f\u3093\u3060\u308d\u3046\u30fb\u30fb\u30fb\u304d\u3063\u3068\uff57
\n\u7d20\u4eba\u306b\u306f\u9bd6\u306e\u7ba1\u7406\u306f\u96e3\u3057\u3044\u30fb\u30fb\u30fb<\/p>\n","protected":false},"excerpt":{"rendered":"

MT\u306e\u7ba1\u7406\u753b\u9762\u306b\u30ed\u30b0\u30a4\u30f3\u3059\u308b\u3068\u30c8\u30e9\u30c3\u30af\u30d0\u30c3\u30af\u4e00\u89a7\u304c\u6d88\u3048\u3066\u3044\u308b\u30fb\u30fb\u30fb \u306f\u3066\uff1f\u4f55\u4e8b\u3068\u601d\u3044\/var\/lib\/mysql\u306e\u4e0b\u3092\u898b\u3066\u307f\u308b\u3068\u30a8\u30e9\u30fc\u30ed\u30b0\u306b 070414 23:07:10 [ERROR] \/usr\/sbin\/mysql […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-500","post","type-post","status-publish","format-standard","hentry","category-5"],"_links":{"self":[{"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/500","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=500"}],"version-history":[{"count":0,"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/500\/revisions"}],"wp:attachment":[{"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=500"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=500"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pecos.ddns.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}