[rt-users] RT2 MySQL DB pruning?

[Ben Browning]

[ben at requests mysql]$ du -h rt2
3.3G    rt2

Hrrrm.

Anyone have any experience with thinning down the database? It is getting 
rather unwieldy.

I know that slicing tickets out entirely is a no-no, but I was thinking 
that a good way to do it would be to replace all "Hi I am a body" and "Hi I 
am an attachment" fields on Dead tickets with "". Anyone have experience 
with this? I am non-SQL savvy.

TIA!

~Ben
---
    Ben Browning <benb at theriver.com>
       The River Internet Access Co.
              Network Operations
1-877-88-RIVER  http://www.theriver.com