Support » Fixing WordPress » how to remove all my posts?

  • Resolved Pandu

    (@pandu)


    I just got started with this and migrated my posts over from Blogger. Unfortunately the comments didn’t come along. I found an updated script that seems to do the trick, except it skips over all the posts because they’re duplicates. There must be a way to delete all of these posts so that I can import them again but with comments. Can anyone tell me how to do that? Thanks

Viewing 4 replies - 1 through 4 (of 4 total)
  • Go to your database manager, maybe phpmyadmin.
    1. Go to your database
    2. Go to the tables wp_posts and wp_comments. The first row should say for: wp_posts = ID and wp_comments=comment_ID.
    3. Check mark the the ID part and click Browse.
    4.There you will see your posts and comments. From there you can delete them.

    Add the wp_post2cat and (potentially) wp_postmeta tables to (2) in vrada’s steps above. Also keep in mind if you modified the $table_prefix in wp-config.php when you installed WordPress, “wp_” in your table names (i.e. the table prefix) will be different.

    Wonderful. That did it, and the job’s done. Thanks for your help!

    it would be a neat feature if there was simply a check box next to each post and so that one could selectively kill posts. (suggestion)

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘how to remove all my posts?’ is closed to new replies.