[rt-users] Archiving the Attachments Table

2008-04-02 Thread Justin Hayes
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

Re: [rt-users] Archiving the Attachments Table

2008-04-02 Thread 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

Re: [rt-users] Archiving the Attachments Table

2008-04-02 Thread Justin Hayes
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