Batch move topics to another board based on topic ID

[spiros]

Is this possible, via MySQL for example?

[Illori]

even if it can be done in mysql we dont recommend doing that as it does not update everything it should. are you not able to use the checkboxes for moderation and move the topics in mass that way?

[spiros]

Well, I am talking about thousands of topics

My forum actually works like a dictionary, so this is part of yearly maintenance, fixing duplicates, etc.

[Arantor]

I think all you should need to do is update the topics and messages tables. Assuming nothing in post moderation and no current reported posts, anyway...

[Illori]

I think all you should need to do is update the topics and messages tables. Assuming nothing in post moderation and no current reported posts, anyway...

would that update the count of topics/messages in each board? and any other related stats?

[spiros]

Wouldn't this be done with Recount all forum totals and statistics?

[Arantor]

I assumed you'd run that afterwards anyway

[Kindred]

well, it would only do one screen's worht of messages at  time... but if you increase the viewing count per screen in your profile, you could do 100+ at a time by turning on the "moderation uses checkboxes" (again, if your profile) and then selecting all messages in the current view and using the batch option at the bottom.

[spiros]

Thanks, Kindred, I know of that method. What I have done is export board topic subjects and IDs to csv, then use Excel to find duplicates. So, finding the topics again via forum Search and doing this manually takes a lot of time... as there are 1000s of duplicates. The key here is topic IDs.