RSS Feed
Twitter
August 20th, 2010 
murrc2 I went on to check my blog as us webmaster usually do first thing when we get online. To my surprise there were no blog posts present on the blog nor were the visitors anywhere near what they should be at this time in the morning. I logged into the back end of my wordpresss blog and saw that there were 0 posts and 0 comments.
Posts were no where to be seen , this worried me greatly. I tried entering a post but they would not save so I thought it might be something to do with my database. If my host had deleted my blog there would be serious trouble. When I logged into phpmyadmin and clicked the table “post” I noticed it had no posts and displayed a message ” your table is corrupt or damaged. Please repair” so that I did and all my posts were back.
Here is how I repaired my table:
To repair a MySQL table, log into your database using phpMydmin web client. Select you database from the database drop down on the left hand side. At this point, you should be looking at a list of all the tables in the database. Check the database table that has crashed and at the select repair table from the drop down options at the bottom of the list of tables. That should fix crashed or corrupted MySQL tables.
If you don’t have phpMyAdmin web client, you can just run the repair table command. From your MySQL query console enter the following.
REPAIR TABLE wp_posts
Popularity: 10% [?]
No related posts.
Posted in 
