Corrupted wp_posts table
-
I recently had a hard drive start to go bad on my web server. I managed to create an image of the entire drive and then spun up a virtual machine using the disk image so I could try and repair my wife’s WordPress site.
I have nearly gotten everything back up and running, except for one major problem, the wp_posts table is corrupted.
I have tried everything I can think of:
1. Manually rebuilt all of the tables and imported the *.idb files to re-populate the data into the tables.
2. Incremented innodb_force_recovery from 1 all the way to 6.
3. Ran ‘optimize table <table_name>;’
4. Set WP_ALLOW_REPAIR and visited /wp-admin/maint/repair.php and ran the repair and optimize option.No luck. I’ve probably put in 100 hours trying to fix this. Yes, I should be backing up the database. Hindsight is 20/20. Yes, I could start over with a “factory fresh” WordPress site, but there are 5 years worth of posts that my wife doesn’t want to lose, if possible.
The error I am getting from the WordPress repair page is this:
The wp_posts table is not okay. It is reporting the following error: InnoDB: The B-tree of index PRIMARY is corrupted.. WordPress will attempt to repair this table…
Failed to repair the wp_posts table. Error: InnoDB: The B-tree of index PRIMARY is corrupted.
- The topic ‘Corrupted wp_posts table’ is closed to new replies.