Fix a no post on WordPress site when the database corrupts.

Last week ago, I was checking my WordPress blogs and found my blog has no post. After that I tried to login to my WordPress Dashboard, and I logged in without any hassle. How come my categories, tags, stats, attachments are fine.

I went to phpMyAdmin by click the phpMyAdmin button on cPanel to check blog’s database, on the structure page of database on my blog has show “wp_post” marked “in use”. It may be particular table was crashed due to an error.

So, I went to MySQL database page on cPanel, then select database and click the “Check DB” button on modify Databases section.

The results show “warning: Tables is marked as crashed” on wp_post table, which is a root cause of no post on my blog.

So, I went to MySQL database page again, and select database and click the “Repair DB” button on modify Databases section.

The repair of the database result seems fine.

After that I went to my blog and the posts have shown. It’s Work!!

Note:
The other way to repair a table in a MySQL database you can use phpMyAdmin by following the step below:

1. Go to phpMyAdmin.
2. Choose the database. If you only have one database, it should choose it by default so you don’t need to do anything.
3. In the main panel, you should see a list of your database tables. Check the boxes by the tables that need repair.
4. At the bottom of the window just below the list of tables, there is a drop down menu. Choose “Repair Table”

Related posts:

1. Fix WordPress upgrade error: No Update Required -Your WordPress database is already up-to-date! I recently upgraded my blog to WordPress 3.x and everything seemed to go smoothly with the process. But after upgraded when I go to the WordPress admin, I still get...
2. How to add Google +1 button to wordpress Theme The Google +1 is hottest social app by Google and many people are really getting serious about the Google +1 is because it will be used as one of the...