I have a site on our network that for some reason today has no content. Nothing in the trash, no comments, no posts, nothing. Even Media is empty. When I try to add a new page I click the Publish button and it just takes me back a blank page listing. I can't add new media or other item either. Links are still there though.
I looked at the tables for the site in MySQL and all the tables are there, and all the content is there, Except for the wp_1234_posts table. It is empty. :(
Last week we had some other problems with missing tables. But all tables were missing from that one. We determined that it was a problem when they were created, but now I'm wondering if they are connected. Here is a link to that forum post. http://wordpress.org/support/topic/database-tables-missing-in-multi-site?replies=11
Possible Cause: Yesterday our server ran out of space for a while and caused some problems. We had to shut down MySQL and then eventually restart the whole server (VM) after making some space. Somehow our .htaccess file got destroyed so we had to rebuild that, but once that was done we thought we were good to go till we learned about this missing data this morning. We can restore from backup if needed, but want to stop this from happening again!
Any thoughts about troubleshooting and what might be going on would be appreciated.