[rt-users] Cleaning Attachments

[Michael Stepanov]

Hi,

Our RT3 system has Attachments table with size about 300GB. We'd like to
clean it by removing old records with files. The rt-shreder can do this job
properly I guess. But there is no way to specify query criteria there. Even
direct delete query is failed.

Does somebody can suggest how to clean Attachments table?

BTW, IMHO it's bad idea to store files in the database cause it isn't
scalable solution and it's very difficult to upgrade/backup/restore DB.

-- 
Cheers,
Michael
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110916/454c2f52/attachment.htm>