Thanks I'll take a look at the Shredder - I was thinking about deleting rows using SQL but if there's an extension to do it I'll use that.
However am I easily going to be able to get files back from the backup if I need them? The files are stored as data in a column of that table. If 3 months down the line I need a file from a Ticket, will I be able to find out which row I need in my backup if the Shredder has removed it from the live RT? Also will I be able to out the data back into a file? Or are you suggesting setting up an archive install of RT and having that run off the backup. So I have a live streamlined install and a bloated backup install. Cheers, Justin ------------------------------------------------------ Justin Hayes Support Manager [EMAIL PROTECTED] On 2 Apr 2008, at 14:18, Benjamin Weser wrote: > 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 >> [EMAIL PROTECTED] >> >> >> >> _______________________________________________ >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >> >> Community help: http://wiki.bestpractical.com >> Commercial support: [EMAIL PROTECTED] >> >> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >> Buy a copy at http://rtbook.bestpractical.com >> > > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com