| T O P I C R E V I E W |
| MarcelG |
Posted - 20 April 2009 : 08:24:39
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? |
| 7 L A T E S T R E P L I E S (Newest First) |
| SiSL |
Posted - 20 April 2009 : 10:14:36
quote:
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. |
| MarcelG |
Posted - 20 April 2009 : 09:39:24
Updating the counts took less than 4 minutes, so that's pretty ok for nearly 40k posts. |
| SiSL |
Posted - 20 April 2009 : 09:26:44
quote:
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 |
Posted - 20 April 2009 : 09:04:19
I knew it was floating around somewhere!  Thanks!
edit
Move completed!
Now updating the forum counts. |
| SiSL |
Posted - 20 April 2009 : 08:48:47
Check out my signature
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=64453
|
| MarcelG |
Posted - 20 April 2009 : 08:43:53
I'm using SQL (2000). |
| ruirib |
Posted - 20 April 2009 : 08:35:07
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... |
