[rt-users] How do I best clean out a RT database?

[Ryan Stepalavich]

We've been running RT since 2001. Our Attachments table in the MySQL 
database has reached over 1.3GB in size. What's the best way to go about 
cleaning that up?

I had thought that a simple "DELETE FROM Attachments WHERE Created < 
"2008*"" would do the trick. That would easily clean up 2/3s of the 
database. Is there a best practices method to go about doing this?

We're on RT 3.6.6

-- 


Ryan Stepalavich
Systems Administrator
S&S Worldwide, Inc.
(800) 537-3451 Ext. 2195
http://www.ssww.com