WordPress version 3.4.2
Thesis Theme version 1.8.5
Hundreds of my posts have become uncategorized because of (I believe) a recent MYSQL server problem at my hosting provider... also, dozens of images aren't displaying in the Media Library...
The hosting provider has restarted the MySQL server once, to no effect, and I'm waiting to hear back from them on further efforts. Other forum posts indicate a that a full "/tmp" directory (?) could be the cause, but hosting provider says that's not the issue here.
The category admin panel in WP admin shows the correct post counts for each category, but once you click through one of them, only a few posts show as assigned to that category. Where is WP getting the post counts from?
Where/how in the database are the category assignments stored? Does this issue sound like it can possibly still be resolved by getting any potential MySQL server communication errors fixed, or getting a /tmp/folder cleared? Or does it sound like data has been lost...?