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
-
by glennrocksvbNo, it doesn't work in vB6. The online/offline status icon has changed to Font Awesome icon in vB6 and the HTML and CSS classes have changed as well....Yesterday, 03:43 PM
-
Get Affordable and Fast VPS for vBulletin -
by nekro711Hello guys,
Im new in this vbulletin thing and while i googled for some info i found this forum.04-15-2024, 04:12 PM
Comment