{"id":2743,"date":"2016-10-27T05:59:03","date_gmt":"2016-10-27T05:59:03","guid":{"rendered":"http:\/\/people.utm.my\/sharulhafiz\/?p=2743"},"modified":"2016-10-27T06:01:02","modified_gmt":"2016-10-27T06:01:02","slug":"mysql-table-is-marked-as-crashed-and-last-automatic-repair-failed","status":"publish","type":"post","link":"https:\/\/people.utm.my\/sharulhafiz\/mysql-table-is-marked-as-crashed-and-last-automatic-repair-failed\/","title":{"rendered":"mysql table is marked as crashed and last (automatic?) repair failed"},"content":{"rendered":"

Looking at error log, you might found this error code –\u00a0mysql error 144 table.<\/p>\n

1st, navigate to\u00a0\/var\/lib\/mysql\/<database><\/p>\n

For MyISAM repair command:<\/p>\n

myisamchk -r <table_name><\/strong><\/p>\n

if above does not work, use this command<\/p>\n

myisamchk -r -v -f .\/<table name><\/strong><\/p>\n

For InnoDB :<\/p>\n

A bit more complicated and not tested yet, so will update this post later.<\/p>\n

Reference :<\/p>\n

    \n
  1. https:\/\/www.a2hosting.com\/kb\/developer-corner\/mysql\/repairing-mysql-databases-and-tables<\/li>\n
  2. http:\/\/stackoverflow.com\/questions\/8843776\/mysql-table-is-marked-as-crashed-and-last-automatic-repair-failed<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    Looking at error log, you might found this error code –\u00a0mysql error 144 table. 1st, navigate to\u00a0\/var\/lib\/mysql\/<database> For MyISAM repair command: myisamchk -r <table_name> if above does not work, use this command myisamchk -r -v -f .\/<table name> For InnoDB : A bit more complicated and not tested yet, so will update this post later. […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[30],"tags":[33,32,31],"class_list":["post-2743","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-innodb","tag-myisam","tag-mysql"],"jetpack_featured_media_url":"","jetpack_likes_enabled":true,"jetpack-related-posts":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5KVXr-If","_links":{"self":[{"href":"https:\/\/people.utm.my\/sharulhafiz\/wp-json\/wp\/v2\/posts\/2743","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.utm.my\/sharulhafiz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.utm.my\/sharulhafiz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.utm.my\/sharulhafiz\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/people.utm.my\/sharulhafiz\/wp-json\/wp\/v2\/comments?post=2743"}],"version-history":[{"count":0,"href":"https:\/\/people.utm.my\/sharulhafiz\/wp-json\/wp\/v2\/posts\/2743\/revisions"}],"wp:attachment":[{"href":"https:\/\/people.utm.my\/sharulhafiz\/wp-json\/wp\/v2\/media?parent=2743"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.utm.my\/sharulhafiz\/wp-json\/wp\/v2\/categories?post=2743"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.utm.my\/sharulhafiz\/wp-json\/wp\/v2\/tags?post=2743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}