If you haven’t experienced a crashed sql database table yet then let me tell you it isn’t a good feeling. I set up a wordpress blog about 6 months ago and have posted one to two posts a day on it, I woke up this morning like I do every morning and sat down to write my first post of the day, I then published it and checked my blog to make sure it appears, so far all is good.
I then went out for a couple of hours to grab some smokes and a bite to eat. When I returned I visited my blog as I was going to write a second post and noticed I was only seeing 404’s. My categories and tags were still there but all my posts I had written over the last 6 months had completely vanished.
First of all I thought someone had possibly hacked into the site and deleted my database but why was my categories and tags still there?
I then logged into my sites cpanel and navigated to phpadmin so I could take a closer look at the database and see what’s happened. I noticed the table that stores all the posts I write was still there but you couldn’t access it and if you did it would give you an error similar to this one:
#145 – Table ‘./xxxxxx_wrdp1/wp_posts’ is marked as crashed and should be repaired
Basically what has happened is your table has some how been corrupted which is something that just happens and cannot be avoided, so what you want to do is regularly back up your posts because you now need to repair the table and there is always the chance that a couple of your posts have been deleted. Once logged into to phpadmin and you have selected your wordpress database look for the table that is corrupt and tick the checkbox next to it, once you have done that at the bottom of the page will be a drop down menu and an option called “repair table” select that and cross your fingers.
Once the repair process has been completed you can now go and see what’s missing if anything from your blog.
I hope you found this post interesting and feel free to leave a comment.
Written By Michael David Tedder
