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?
Announcement
Collapse
No announcement yet.
sql to find topics greater than 10 years old
Collapse
X
-
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.Helpful? Donate. Thanks!
Fast VPS Host for vBulletin:
A2 Hosting & IONOS
- Top
- Translate
- Bottom
-
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.
- Top
- Translate
- Bottom
Comment
Users Viewing This Page
Collapse
There is 1 user viewing this forum topic.
- Guest
Latest Posts
Collapse
-
Reply to Topic Starter Ribbon for vBCloudby glennrocksvbThanks for reporting. I'll bookmark this post and check the issue.04-22-2024, 06:40 PM
-
Reply to Topic Starter Ribbon for vBCloudby MitchIt seems since the 6.0.4 update the topic starter is no longer working04-22-2024, 05:02 PM
Comment