Table is marked as crashed and should be repaired

I am getting this error in wordpress phpMyadmin

#145 - Table './DB_NAME/wp_posts' is marked as crashed and should be repaired 

When I login to phpMyadmin, it says wp_posts is "in use"

My website is currently down because of this.

I googled this problem, but I don't see the "repair" button on phpMyadmin. Please let me know how to fix this. I am not sure where to issue PHP command. Please advise, my proficiency with PHP is very basic.

Solutions

Run this from your server's command line:

 mysqlcheck --repair --all-databases

Here is where the repair button is:

alt text

I had the same issue when my server free disk space available was 0

You can use the command (there must be ample space for the mysql files)

REPAIR TABLE `<table name>`;

for repairing individual tables

Similar questions

Yoast Force Rewrite Crashed Site
I just applied force rewrite in WordPress SEO by Yoast plugin and now cannot access my site at all am getting a Error 330 (net::ERR_CONTENT_DECODING_FAILED): Unknown error. message in Chrome and "Content Encoding Error The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression." in Firefox Please H...
Wordpress crashed during update
I was updating Wordpress when my wifi dropped - now I'm getting..... error: Call to undefined function wp_raise_memory_limit() in /www/sites/46e/fb3/www.mywebsite.co.uk/web/wp-admin/admin.php on line 141 Any ideas how I can fix this?
Deactivated Visual Composer plugin, site crashed, what to do?
So I have deactivated the Visual Composer plugin from the WP admin panel and now the whole site is down and I'm getting this error: Fatal error: Call to undefined function vc_map() in xxxxxxx/httpdocs/wp-content/plugins/df-shortcodes/vc-mod/vc_mod-extend.php on line 135 And this line does not even correspond to the Visual Composer plugin, how can I...
MySQL crashed because of the large number of requests
I often began to fall down mysql. I recorded a large number of requests: How to identify the problem and fix it?
Server crashed from traffic spike, now getting database connection error
So I posted a new blog on my site and promoted it on my facebook where the traffic spike was far bigger than anticipated, the server went down from the volume of traffic and after it was rebooted I am now getting a database connection error. I contacted my server host and they told me this: "I was able to get the relevant database details from the ...
Wordpress update crashed admin
I recently had to change my password via database using md5 hash generator. After, I tried to create a post but it had 'submit for review' instead of post. So I then updated to the latest wordpress. Now when I go to wp-admin, it just loops through the update screen. Click to update, Success, back to Click to update. Anyone know what's going on?

Also ask

We use cookies to deliver the best possible experience on our website. By continuing to use this site, accepting or closing this box, you consent to our use of cookies. To learn more, visit our privacy policy.