Moving threads from one forum to another using MySQL
 

Hello

For some reasons I have to move certain threads from one forum to another using MySQL. I wrote this query which does the work, but I am not sure if that's a perfect way to do it or you have to update other tables too. Any help will be appreciated. Here's my query:

UPDATE thread
SET forumid = xx
WHERE threadid IN (xxxx, xxxx, xxxx, threadids, xxx...);

Is their a reason you can not use the Moderation Tools to move them?

That query will do it just fine.

You should run the update forum counters afterwards to correct forum totals.

(I would also echo the question above).

There are lots of threads and I have to move them to many different forums. I have thread ids already and to which forums they need to be moved to. That's the reaon I want to do it by running queries. Moderation tools will take ages.

--------------- Added [DATE]1377442709[/DATE] at [TIME]1377442709[/TIME] ---------------

Thanks Paul