[SOLVED] DB clean up

[gpayo]

Hello colleagues,

We are using OTRS in our company for +5 years. The current version we user is 2.3.4 with a MySQL DB.

Currently we use around 19Gb in DB data and I need to start thinking a way to free some space there. Ideally I'd like to find a way in which I can back up the data by years and the erase that data out of the DB and only keep one year of tickets.

The only script I've found is the one called

Code: Select all

/scripts/backup.pl

but that scripts only backup the entire DB (plus source code) but does not delete any.

Can anyone help on this? If you can give the needed SQL sentences I'd do it myself.

Thanks a lot

[crythias]

You could use Generic Agent to search and delete old tickets.

[gpayo]

Yes, I could do that but then... How can I backup them?

[crythias]

Make a database dump.

[gpayo]

Thanks crythias, you are very helpful.

[crythias]

I should have posted that if you're using FS/FileSystem storage of attachments, you'll want to address that issue as well.