Actually it’s safer to use the Manage->Posts screen for that.
But, after doing a database backup and you decide Manage->Posts is just too easy ;), then know that wp_posts holds the posts. The categories and tags and their link to applicable posts are kept in the wp_terms_relationships table. Any custom fields for those post are kept in wp_postmeta. Any comments related to the posts are in wp_comments.
Michael – the only reason I am considering doing the SQL is that I keep getting timed out on my post delete from the manage post page. It literally churns for 60 to 90 seconds then times out.
This along with the open MySQL connections problems I am having is making me consider switching to drupal or another CMS.
Thanks.
Amen to that, Michael. I’m curious as to why the OP has duplicate posts in the first place. A redundant import or conversion? Might this be the reason for the slowness?
it’s probably due to connection timeouts when posting, and bashing the publish button repeatedly.
people in greenland simply shouldn’t be using hosts in fiji, or similar.
I clicked the fetch on the campaign ONCE and it took for ever so I finally just stopped the page. I think it imported about 1000 records. I am reluctant to use it again.