Repairing WordPress database crush!
This week I wanted to edit a post. When I clicked on the update button, …. A problem: all the posts and pages and comments were gone. Just like that. I went into the PHPmyadmin section of the control panel to look at the database and here’s the error I found:
“wp_posts” is marked as crashed and should be repaired.
I can’t tell you how frightened I was. All my posts gone. To make the matter worse the only backup I had was 3 months old!
Fortunately, a search on the internet helped me fix the problem. Here is how I fixed it:
- Go to in PHPmyadmin,
- click the check box next to the corrupted table (for example, wp_posts).
- The table will probably say “in use”.
- Use the dropdown menu at the bottom to select “repair table”.
- That’s it.
Of course, the ideal thing is to have backups now and then. This will help you reinstall your tables when a problem occurs.