XF 2.1 Approaches to splitting thread archive of 60,000 posts?

[Monkeytime]

I imported almost 60,000 posts into one thread. It goes back decades.

I want to split this archive into yearly threads.
Or, if that proves too hard, just split into "everything before June 2020" and "everything after June 2020".

I won't be doing it, my smarter db admin will, but I'd like to hear from some opinions on the recommended approaches?

Thank you.

 

[Paul B]

Our recommended approach is to use the moderator tools available on the thread - select the posts and move them to a new thread.

Anything else, such as manually editing the database, is unsupported.

 

[Monkeytime]

I now see that. Thank you very much. Is there a way to batch select posts based on date?

 

[Mr Lucky]

The problem I see is that when selecting messages in a thread, select all only applies per page and the default maximum posts per page is 100.

If you could change that to 1000 or 5000 (via some template edit maybe?) you may be in with a chance. If you can do that (temporarily while you undertake this task) it could be the way to go but I assume it make make a huge hit on your server resources while doing it.

 

[beerForo]

Here's another solution. You could create sub-forums with the yearly dates but they are link forums and they link to the first post of that year so you could keep the thread as a megathread. So in essence you have something like this:

Archive (Parent forum) the megathread resides in.

• 2019 (Link sub-forum and it links to the first post in 2019)
• 2018 (Link sub-forum and it links to the first post in 2018)
• Etc.

 

[Monkeytime]

If you could change that to 1000 or 5000

Yep, I found that limit too. I started manually (on a backup server) but gave up after 3 pages because thousands of pages to go.

You could create sub-forums with the yearly dates but they are link forums

Very clever idea. I'll consider it. Thanks. If not now, this will come in handy someday.