11 {{ upvoteCount | shortNum }}
11 {{ upvoteCount | shortNum }}

How to Repair How to Repair Crashed Wordpress Table

by mkohtm
7 replies
Today, I had a small experience with crashed wordpress table on one of my sites. When I login to the wordpress site, all the posts and pages were gone.

Was worried because I didn't backup my databases. After searching the net for solution for some time, finally I got it resolved.

When I was trying to resolve this, I thought it might be useful to take this opportunity to do screenshots for the steps taken (crashed table don't happen often, I suppose )

(1) Here's the screenshot of the site after the table 'wp_posts' was crashed



(2) The Wordpress Dashboard shows "0" posts (where are my posts )


(3) Login to cPanel and open phpMyAdmin. Noted that the table wp_posts is in use. No records...


(4) Click on the crashed table, this case "wp_posts". An error message '.../wp_posts' is marked as crashed and should be repaired is displayed.


(5) Checked the table to repair and scroll down to select 'repair table' at the dropdown menu.


(6) A message stating "... executed successfully displayed"


(7) Looking at the database, the table looks normal now. With number of records showing.


(8) From the dashboard, the posts and pages are back!


(9) The website is back to normal with the content.


Hope it will help someone with similiar encounter. Going to backup my databases now..

Michael
#crashed #repair #table #wordpress
  • Profile picture of the author jimstoddard
    Thanks for taking the time to post this! Have not had the problem before, but posts like this are really helpful if it does rear it's ugly head.

    Just an FYI...Wordpress 3.01 has a very serious security flaw in it, as in the "no joke upgrade NOW" type of security flaw. Your choice of course, just wanted to make sure you are informed.
    {{ DiscussionBoard.errors[3160117].message }}
  • Profile picture of the author edmundpelgen
    Thanks very much for this guide. Just happened to me now and your post saved me having to go through a full restore.

    Cheers

    Edmund
    {{ DiscussionBoard.errors[5604289].message }}
  • Profile picture of the author infohog
    This post is over a year old but it saved my butt! Thank you for taking the time to post it and save my sanity. Very much appreciated!
    Signature
    Matthew D.
    TiltRight.com
    {{ DiscussionBoard.errors[5649558].message }}
    • Profile picture of the author mkohtm
      Originally Posted by edmundpelgen View Post

      Thanks very much for this guide. Just happened to me now and your post saved me having to go through a full restore.

      Cheers

      Edmund
      Originally Posted by infohog View Post

      This post is over a year old but it saved my butt! Thank you for taking the time to post it and save my sanity. Very much appreciated!
      You're welcome, glad that it's helpful to you
      {{ DiscussionBoard.errors[5776170].message }}
  • Profile picture of the author andreisaioc
    maybe try to keep back ups first.
    Signature
    Fiverr Script | WordPress Auction Theme | Classified Ads Software | Freelancer Script | directory software
    {{ DiscussionBoard.errors[5656845].message }}

Trending Topics