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
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
