[rt-users] Archiving the Attachments Table

[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 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
justin.hayes at orbisuk.com



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
>> 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
>>
>
> _______________________________________________
> 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