WordPress Pages and Posts content missing or pages blank? Use PHPMyAdmin to fix WordPress tables
If (suddenly) your WordPress site is missing content, chances are that one or more tables have crashed.
Using PHPMyAdmin connect to the WordPress database.
The database info can be found inside wp-config.php in your WordPress root folder.
Once you connect to the database via PHPMyAdmin and can see all the WordPress tables, start clicking on each table in the PHPMyAdmin interface.
If you get an error like below:
#144 – Table ‘./yourdatabase_yoursite/wp_postmeta’ is marked as crashed and last (automatic?) repair failed.
There’s a simple fix. Execute the following SQL command for each table that is reported as crashed. In the examples below, ‘wp_postmeta’, ‘wp_posts’ are being repaired.
PHPMyAdmin has a SQL interface (look for the SQL icon) where you can run the following SQL commands.
Example 1: REPAIR TABLE wp_postmeta
Example 2: REPAIR TABLE wp_posts
You should see this message:
Your SQL query has been executed successfully
The site should be fine now.