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

[Ruslan Zakirov]

Hello,

You can do delete from attachments, probably history of those old
tickets will be just empty without any content. You can download
shredder extension from CPAN. Upgrade to 3.8.x where shredder right in
core. If you upgrade to 3.8 then you can use dirty deletion tool from
RT-Extension-Utils. This one is just set of SQL queries that drop all
tickets with status equal to 'deleted' without any backups, but very
fast.

Note that ibdata files in this case stay at the same size, but space
got reused later.

On Fri, Jul 9, 2010 at 7:39 PM, Ryan Stepalavich <ryans at ssww.com> wrote:
> 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
>



-- 
Best regards, Ruslan.