1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. This forum has been archived. New threads and replies may not be made. All add-ons/resources that are active should be migrated to the Resource Manager. See this thread for more information.

How to mass move all threads from one forum to another

Discussion in 'Tips and Guides [Archive]' started by Kaiser, May 30, 2011.

  1. Kaiser

    Kaiser Well-Known Member

    This is just a simple guide on how to move all threads from one forum to another on your XenForo. If you have huge amounts of threads in a certain forum which equals to alot of pages, it can be difficult to go from page to page selecting all threads to move them from one forum to another. (Been there myself) XenForo should have a feature for this by default, but it doesn't unfortunately.

    To move all threads/posts in a particular forum to another one, you would run the following sql query in phpmyadmin:
    UPDATE xf_thread SET node_id = 123 WHERE node_id = 456;
    123 being the ID of the new forum, and 456 being the ID of the old forum. (Thanks to Mike for the query)

    Then you would go to your ACP > Tools > Rebuild Caches > Rebuild Thread Information & Rebuild Forum Information.

    Hope this helps. I recommend you take a Backup of your forum before running any queries.
    Jason29, ibrian, Rubber Jesus and 9 others like this.
  2. Digital Doctor

    Digital Doctor Well-Known Member

    Does this mean there is no easy way to move a forum to be a subforum of another forum ?
    I have 5 admin-only forums .... I've decided to make a Private forum and make the 5 admin-only forums subforums of the Private forum.

    Possible to move them all ?
    or is it:
    a make forums, move posts, delete old forums thing ?
  3. Brogan

    Brogan XenForo Moderator Staff Member

    Just reassign the parent node in the ACP.

    This query is for moving threads, not forums.
    Digital Doctor likes this.
  4. Digital Doctor

    Digital Doctor Well-Known Member

    Oh there it is .... I need sleep.
    I was looking in the node tree list for the option.


Share This Page