Huumm... still didn't try it but this query should do the trick: DELETE FROM Tickets WHERE Created <= date_sub(NOW(), interval 2 year);
Cheers *Flávio Moringa* Project Leader Caixa Mágica Software Energia Open Source Rua Soeiro Pereira Gomes, Lote 1 - 4.º B, Edifício Espanha, 1600-196 Lisboa - Portugal Tel.: +351 217 921 260 Fax: +351 217 921 261 http://www.caixamagica.pt https://twitter.com/flaviomoringa https://www.facebook.com/flaviomoringa<https://www.facebook.com/flavio.moringa> http://pt.linkedin.com/in/flaviomoringa http://people.caixamagica.pt/flaviomoringa 2013/4/9 Flavio Moringa <[email protected]> > I, > > thanks a lot for your help.... > > The util "rt-delete-tickets-mysql" seems to be perfect for what I > want.... I just have to change the initial query from: > "DELETE FROM Tickets WHERE Status = deleted" > to > "DELETE FROM Tickets WHERE LastUpdate = '2 year ago'" > > > Now I just have to find the right query... > > Again thanks a lot for your help... I didn't know about that utils > package... > > Cheers > > *Flávio Moringa* > Project Leader > > > > Caixa Mágica Software > Energia Open Source > Rua Soeiro Pereira Gomes, Lote 1 - 4.º B, > Edifício Espanha, 1600-196 Lisboa - Portugal > Tel.: +351 217 921 260 Fax: +351 217 921 261 > http://www.caixamagica.pt > https://twitter.com/flaviomoringa > https://www.facebook.com/flaviomoringa<https://www.facebook.com/flavio.moringa> > http://pt.linkedin.com/in/flaviomoringa > http://people.caixamagica.pt/flaviomoringa > > > > 2013/4/9 Bart <[email protected]> > >> This page contains the info on the command: >> >> >> - http://bestpractical.com/rt/docs/3.8/rt-shredder.html >> >> >> And some info if you want to use the API: >> >> >> - http://bestpractical.com/rt/docs/3.8/RT/Shredder.html >> >> >> Another thing you might want to look at are the extension Utils: >> >> >> - >> http://search.cpan.org/~ruz/RT-Extension-Utils/lib/RT/Extension/Utils.pm >> - http://search.cpan.org/~ruz/RT-Extension-Utils/MANIFEST >> >> >> As Kevin puts it, Utils are Ruslans bag of tricks. It also contains a >> commando for extracting attachments/deleting tickets, so maybe that's what >> you can use to make things a bit more easy. (the manifest page shows the >> included commands) >> >> >> Hope this helps a little. >> >> >> >> 2013/4/8 Flavio Moringa <[email protected]> >> >>> I guys, >>> >>> I haven't come across a straight answer to this, so my apologies if this >>> has been answered before. >>> >>> I have a 3.6 Request Tracker instance running.... (and no.. updating >>> right now is not possible).... >>> >>> I want to delete all tickets (and respective attachments, etc) that are >>> older than 2 years... >>> >>> My approach is using rt-shredder... by installing the cpan module ( >>> http://search.cpan.org/dist/RTx-Shredder/lib/RTx/Shredder.pm) >>> >>> So what is the cli command to do this? I don't need backups.. so no >>> dump is required.... >>> >>> I have about 600 Gb worth of data.... 99% on the attachments table.... >>> And want to clean all this up... >>> >>> There is an answer on the mailling list about this on Jul 13, 2004... >>> that simply says that to delete for a giving year do: >>> >>> rtx-shredder YYYY-MM-DD >>> >>> But seems to old... >>> >>> Can you help me? seems like a basic think to do... >>> >>> Thanks in advance. >>> >>> Yours trully >>> >>> *Flávio Moringa* >>> Project Leader >>> >>> >>> >>> Caixa Mágica Software >>> Energia Open Source >>> Rua Soeiro Pereira Gomes, Lote 1 - 4.º B, >>> Edifício Espanha, 1600-196 Lisboa - Portugal >>> Tel.: +351 217 921 260 Fax: +351 217 921 261 >>> http://www.caixamagica.pt >>> https://twitter.com/flaviomoringa >>> https://www.facebook.com/flaviomoringa<https://www.facebook.com/flavio.moringa> >>> http://pt.linkedin.com/in/flaviomoringa >>> http://people.caixamagica.pt/flaviomoringa >>> >>> >> >> >> -- >> Bart G. >> > >
