How to repair a crashed wordpress posts database table ?

Today suddenly our wordpress based this website stopped working and I received an Jetpack alert that our website is offline.. when I tried to to check by visiting the website, I seen following 3 obervations,

  1. When visited on homepage https://lynxbee.com, I could see an error message as,
lynxbee

2. I had allready logged into dashboard before error occured, so when checked in dashboard, I couldn’t see any posts listed in “Posts” -> “All Posts” .. this really scared me, as don’t know what happened to all my data..

3. As final observation when I tried to check error logs from the website, I could see lots and lots of errors similar to as below,

WordPress database error Table './wp_posts' is marked as crashed and last (automatic?) repair failed for query SELECT * FROM wp_posts WHERE ID

So, it seemed somehow the wp_posts database table had got crashed, the reason of which I don’t know..

Related :   Check if user is registered or not in WordPress and redirect URL after login

Solution : The answer to this problem to recover the website is try and repair the database table.. if everything goes fine, you should have your website recovered successfully.. following is the procedure we followed to recover our website..

Login to your cpanel and select phpmyadmin

From phpmyadmin, select your website’s database which is having error and click on the same to expand the tables

Now, select the “wp_posts” table and from bottom “With Selected” click on “Repair table”

Once the table “wp_posts” is repaired, you should see the success message as below..

With above steps we are able to recover our website successfully and immediately website started working with all posts recovered.


lynxbee_ezoic

Subscribe with Valid Email Id to receive updates in Inbox. ( Secured by Google FeedBurner )

   


Leave a Comment

Android Android Applications Android Build system Android Commands Application Libraries Application Stack / User Interface Bash / Shell Scripts Bluetooth driver Cloud Technologies Commands and Packages Compilation Content Management System Core Kernel C Programs Development & Build Development, Debugging and Performance Tools Development Environment Setup Django & REST Api Errors & Failures Git Hardware Platforms HTML JAVA Programs Linux, OS Concepts and Networking Linux Device Drivers Linux Host, Ubuntu, SysAdmin Linux Kernel Linux Networking Middleware Libraries, HAL Multimedia Audio, Video, Images NDK / Middleware / HAL OS Concepts PHP Programming Languages Scripting and Automation Search Engine Optimisation ( SEO ) Social Media Source Code Management ( SCM ) System Administration, Security Testing and Debugging Uncategorized Web design and development Website Hosting Wordpress Yocto / Bitbake / Openembedded