How to mass move all threads from one forum to another

[Kaiser_imported]

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.

Source: http://adminbb.org/threads/how-to-mass-move-all-threads-from-one-forum-to-another.2874/

 

[Floris]

Awesome. I seriously needs this. Thank you so much.