Our OTRS database has grown to over 1.5 GB. We are eager to trim it down without losing the tickets. Many of our tickets have very large attachments that we don’t need anymore. We would like to delete the attachments on tickets that are more than 90 days old, but keep the tickets themselves. This change would allow our customers to respond to old tickets and allow us to see the history, without saving the unnecessary attachments.

We have attempted to do this a couple of times, but each time we end up deleting the tickets or losing other data inside the tickets.

Is there a prescribed way to complete this task?

Is there another way to significantly reduce the database size without losing the data?

Thank you for your help.

Travis Murdock

Cloudmark

System details:

OTRS 1.1.1

mySQL database