Archiving the Attachments Table

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@orbisuk.com

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:

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@orbisuk.comOn 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@orbisuk.com


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com