Thanks stacef!
I was about to go squirrelly and then came across your advice.
I was missing 280 or so posts after importing the database into a new blog name on a new server. Also going from WordPress version 2.0 to 2.7
Going through the wp_posts table, I could see that all the posts were there…. just not actually showing up in the blog itself.
The issue turned out to be no data showing in post_type within the table. I added the word ‘post’ to each entry – and Voila!
Anyone who doesn’t know databases, get in touch with your host and ask them to check your WordPress database, wp_posts table, and then check each entry to see what info is in post_type. If it’s anything other than the word ‘post’, then have them change it.
Worked for me.