Thanks for the script, Bohuslav.
I think it'll come in handy, since my db too is getting bigger&bigger....
 
Ciao, d.


Da: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Per conto di Bohuslav Blín
Inviato: lunedě 29 settembre 2008 21.49
A: otrs@otrs.org
Oggetto: [otrs] Exporting attachments from DB to FS

Hi all,
i had big DB with otrs data, because of many attachments (like JPG, PDF,..). My daily backup was almost 2GB.
So I switch Ticket::StorageModule:from DB to FS, because I backup FS incrementaly.
But I also wanted to export existing data to FS.

So I created script for this. Now my daily backup mysql with otrs is 4MB :)

I hope this script will be helpful for somebody else too.

So here it is:
http://pastie.org/281623

(This script is using Ruby and )

Bohuslav Blin