Having some WordPress errors lately — like “…marked as crashed and last (automatic?) repair failed”? Did you ever encounter a moment when suddenly all your blog posts disappeared, lost, deleted? Your first thought maybe is that someone hacked your blog and erased all your post. So you changed your password immediately and thought what to do next. Should you do a restore to your latest backup? What about if you did not make a backup of your database?
Relax. Nothing was lost. None of your post was deleted. If you get an error like this:
#144 – Table ‘./wp_posts’ is marked as crashed and last (automatic?) repair failed, then it is very likely that there is just a corrupted table in your database that needs to be fixed or repaired.
Here are the steps you have to do to get all your posts back.
1. Log in to your host server.
2. Find phpMyAdmin and sign in to your account.
3. Click on your database name on the left side of the page. This is the database of your blog that contains all your posts. In some cases, a list of tables will appear on the right page. If none will appear, do not worry. Proceed to the next step.
4. Click on SQL in the tabs on the top.
5. In the query box enter: repair table wp_posts and then click Go. (You will need to replace wp_posts with whatever table you are having an issue with if it’s not this table.)
6. A message will say if the repair was successful.
Open your blog. Voila! all your posts are back again!