How to transfer all post from one category to another (2 posts)

  1. foxalert
    Posted 2 years ago #

    Hi there,

    I have an old category which contains hundreds of posts.

    Now i want to move all those posts to another new category.

    Can someone tell me how i move all posts from one category to another category?

    Thank you!



  2. Tara
    Volunteer Moderator
    Posted 2 years ago #

    - In the Dashboard/Manage/Posts you can click the edit tag of any post, unmark the original category where the post is published, mark any category (ies ) and republish ( Save ).
    This would be tedious if you are moving many posts, but doesn't require any MySQL knowledge.

    - If you feel comfortable messing with MySQL:

    go into your database and find the table wp_categories (it might be named something else similar depending on your tables' prefixes).

    There, note the cat_ID number for the category you want to move the posts FROM as well as the cat_ID for the category you want to move the posts TO.

    Then go to table wp_post2cat and in the field named "category_id" update every instance of a FROM category number to the number of the TO category. If you know a little MySQL it should take a couple of seconds to do.

    There you'll see the fields "rel_id," "post_id," and "category_id."

    - Either way, make sure you backup everything (including your database) before doing any actions, just in case.

Topic Closed

This topic has been closed to new replies.

About this Topic