{"id":1087,"date":"2019-01-12T10:31:09","date_gmt":"2019-01-12T13:31:09","guid":{"rendered":"http:\/\/blog.abratel.com.br\/?p=1087"},"modified":"2019-01-12T10:31:09","modified_gmt":"2019-01-12T13:31:09","slug":"tabela-no-mysql-crashed-is-marked-as-crashed-and-last-automatic-repair-failed","status":"publish","type":"post","link":"https:\/\/blog.abratel.com.br\/?p=1087","title":{"rendered":"Tabela no mysql crashed &#8220;is marked as crashed and last (automatic?) repair failed&#8221;"},"content":{"rendered":"<p><strong>Problem:<br \/>\n<\/strong><\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\n#144 - Table '.\/mya2billing\/cc_call' is marked as crashed and last (automatic?) repair failed\r\nor \r\nERROR 144 - Table 'BLABLABLABLABL' is marked as crashed and last (automatic?) repair failed\r\n<\/pre>\n<p>If your MySQL process is running, stop it. On Debian\/Red Hat\/Centos:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nsudo service mysql stop\r\n\/etc\/init.d\/mysql stop\r\n<\/pre>\n<p>Go to your data folder. On Debian:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\ncd \/var\/lib\/mysql\/$DATABASE_NAME\r\n<\/pre>\n<p>Try running:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nmyisamchk -r $TABLE_NAME\r\n<\/pre>\n<p>If that doesn&#8217;t work, you can try:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nmyisamchk -r -v -f $TABLE_NAME\r\n<\/pre>\n<p>You can start your MySQL server again. On Debian:<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nsudo service mysql start\r\nor \/etc\/init.d\/mysql start\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Problem: If your MySQL process is running, stop it. On Debian\/Red Hat\/Centos: Go to your data folder. On Debian: Try running: If that doesn&#8217;t work, you can try: You can start your MySQL server again. On Debian:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/1087"}],"collection":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1087"}],"version-history":[{"count":1,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/1087\/revisions"}],"predecessor-version":[{"id":1088,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/1087\/revisions\/1088"}],"wp:attachment":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}