[rt-users] Cleaning Attachments

[Michael Stepanov]

On Fri, Sep 16, 2011 at 5:48 PM, Kevin Falcone <falcone at bestpractical.com>wrote:

> On Fri, Sep 16, 2011 at 05:12:48PM +0300, Michael Stepanov wrote:
> >    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.
>
> rt-shredder allows query criteria.
>

I tried rt-shreder from 3.8.2 and it accepts only files_only, file  and
longer. No query.


>
> -kevin
>
> >    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.
>
> --------
> RT Training Sessions (http://bestpractical.com/services/training.html)
> *  Chicago, IL, USA — September 26 & 27, 2011
> *  San Francisco, CA, USA — October 18 & 19, 2011
> *  Washington DC, USA — October 31 & November 1, 2011
> *  Melbourne VIC, Australia — November 28 & 29, 2011
> *  Barcelona, Spain — November 28 & 29, 2011
>



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