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
