Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/68561?pagenum=1
05 November 2025, 09:23
Topic
MarcelG
move all topics from one forum to another
20 April 2009, 08:24
Guys, perhaps this has been asked (and answered) before, but I'm looking for a quick script to move all topics (including their replies) from one forum to another forum (within one site).
In my case it's from forum ID 50 to forum ID 20.
It concerns 328 topics with 2218 replies.
Does anyone have a nice script laying around for that?
Replies ...
ruirib
20 April 2009, 08:35
What database are you using?
I can write you one that will work with MySQL and SQL Server, except for the update counts part, but you can run that manually afterwards...
I knew it was floating around somewhere! Thanks!
edit
Move completed!
Now updating the forum counts.
SiSL
20 April 2009, 09:26
Originally posted by MarcelG
Now updating the forum counts.
Heh, suprised you even posted in it :P
May patience of the prophets be with you on updating counts if you have huge number of posts. Without Rui, I would not have such opportunity to update my counts or archive my posts EVER.
MarcelG
20 April 2009, 09:39
Updating the counts took less than 4 minutes, so that's pretty ok for nearly 40k posts.
SiSL
20 April 2009, 10:14
Originally posted by MarcelG Updating the counts took less than 4 minutes, so that's pretty ok for nearly 40k posts.
Lucky you, over 400k here and it either times out server side or client side :p It never ends normally.
Thanks to Rui, supplied me a SQL procedure to ease up pain down to 15 seconds.
Thanks!