When posts and pages in your self-hosted wordpress blog are disappeared, it’s all due to the crash in the MySQL database. Read on to fix it.
Suddenly, five thousands more posts/articles and all static pages disappeared in one of my self-hosted wordpress blog. Don’t panic! I say to myself. That’s not the work of a hacker. The first thing I do is to email Hostgator, the webhosting service where I hosted the blog. While awaiting the respond from them, I made a quick search on similar occurrences. And it turns out this things did occur quite few times in self-hosted wordpress blog. Not so clear which to blame: wordpress or the host. The important is you should fix it quickly.
The best thing to fix it is by asking your hosting provider to fix it for you.
Just in case they don’t want to do it, you can do it yourself by this simple steps:
- Login to your CPanel which located at yoursite.com/cpanel
- Go to MySQL Databases
- Select WordPress Database
- Click Repair. Done.
Hope it works.
Update: The problem has been fixed by my host provider. They said, my website has experienced crash in MySQL database. And it’s been repaired.
Further Readings:
You’re the MAN!
You’re Awesome!
All my posts and pages were gone. I did what you’ve written and it worked!