[rt-users] Archiving the Attachments Table

[Benjamin Weser]

Why don't you make a general backup of your mysql database (you can also 
export this table only) and then use the Shredder to get rid of the 
attachments?

Justin Hayes schrieb:
> Hi,
>
> Our attachments table is currently taking up 2.3gb and is easily the  
> largest table in our RT 3.6.3 DB.
>
> I know that that table contains both the text of comments/replies as  
> well as the files that are attached to tickets.
>
> Has anyone looked at archiving this table? Ideally I'd like to keep  
> textual comment/replies but remove attached files. I'd also like to do  
> it in a way that would mean I could get them back later if needed.
>
> Any ideas?
>
> Justin
>
> ------------------------------------------------------
> Justin Hayes
> Support Manager
> justin.hayes at orbisuk.com
>
>
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>