WordPress.org

Ready to get started?Download WordPress

Forums

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

  1. foxalert
    Member
    Posted 7 months 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!

    Regards,

    Martin

  2. Tara
    Member
    Posted 7 months 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.

Reply

You must log in to post.

About this Topic