version 6.6.1
What is the best way to go about cleaning up old PMs, notifications et al. in the PM system.
I have about 3700 members and have already done the "voluntary" request to clean up old PMs...
Looking throught the pm_xxx directories, it is clear that there are tons of old PMs that need to go.... (files that haven't changed dates since migration to current server).
My concern is this... I have a file handle limit on my site of 60,000. I am currently at 52K+... I don't want old PM crap unnecessarily using up my increasingly valuable remaining file handles.... or whatever term you want to give file count.
Unfortunately, I don't currently have shell access to the board site and will need to do whatever I do via FTP.
The PM cleanup will be done after I do a valid email checkup, and an inactive member purge...
Sure would appreciate some guidance here... I don't want to do something that will toast the install...
I'm assuming that I could use a procedure similar to the following:
-Set a prune date... in this case 11/15/03
-Shut the board down.
-Delete all files in pm_notify with date of 11/15/03 or prior.
-Delete all files in pm_users with date of 11/15/03 or prior
-Delete all files in the A, B, C.... subdirectories under pm_topics with date of 11/15/03 or prior (a long and tedious job)
Leave the pm_buddy and pm_ignore directories alone... as well as the pm_info (since it is just registering the incrementing count stuff).
Would I need to rebuild the metadata and/or indexes? Which ones?
It'd be really cool if there were a CP routine that could do this for us...
I could get about 15,000 file handles back by cleaning out the old PMs... Hate to do it, but need the resources... and I don't feel the PM system should be used to archive stuff...
Am I headed in the right direction? What am I missing/forgetting?
Thanks!
