• 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.

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Corrupted wp_posts table’ is closed to new replies.