Forum Prune
 

Seeing as vB decided to make it so only their coders could understand and complete this task - How do you do it?

I'm on the page to prune but I'm asked some seriously dumb questions when all I want to do is clear posts over 365 days old.. My db is close to 1/2gb and needs seriously cleaning..

Can someone kind enough put up a recommended setting for each question please.

Kind regards

Original post date is at least '365' days ago

Original post date is at most '0' days ago
- Note: leave this at 0 to specify no limit.

Last post date is at least '365' days ago

Last post date is at most '0' days ago
- Note: leave this at 0 to specify no limit.

View Options
Thread has at Least '0' Replies

Thread has at Most '-1' Replies
- Note: leave this at -1 to specify no limit.

Thread has at Least '0' Views

Thread has at Most '-1' Views
- Note: leave this at -1 to specify no limit.

Status Options
Thread is sticky: Thread remains at top of list thread listings
Yes No Either

Thread State

Visible
Awaiting Moderation
Deleted
Any

Thread Status

Open
Closed
Redirect
Not Redirect
Any

It's just a darned shame we still have no method of offloading the pruned data. It all has to be deleted. :(

You could back it up from MySQL if you wanted, but if threads aren't used for over a year or so I don't see the point of keeping them unless they contain reference information.

I'd like to keep our old posts just for posterity. Offload them to an easily searchable text file, maybe using the Print routines. Absurd to force us to keep old posts in the db.

I cant believe there is not a hack or something to auto offload a post into another database as an archive so you can archive by year..

Seems logical, not sure why it hasn't been done yet...

I've seen this type of feature in other discussion board software.....the ability to prune old messages into an HTML file that you post on the web for users to view, like an archive.