sql to find topics greater than 10 years old

[rnedelkow]

One of my forums has been around for a while and I'd like to identify topics that are over 10 years old. Any examples of an sql query to pull them out? I'd also like to back them up to an external repository for future reference. The purpose of doing this is to shrink the size of our db. Is this possible?

[glennrocksvb]

You might be able to find 10 year old posts using the Advanced Search page. Specify "07/10/2007" as the "To" date in the "Date Range" option. You won't be able to backup the posts that way but you will be able to delete the posts from there.

[rnedelkow]

Thanks Glenn. I'll give it a try.

[rnedelkow]

The advanced search option lists topics created between certain dates, and that's good. What about a mass prune option? How would I go about deleting all topics older than 10 years old? Inline only? I thought this was an option in previous versions. I only see mass prune users in admincp.