Hi Daniele,
please let me know if you succeed exporting the attachmentes from the db to FS
I've a 200k ticket db that has reached 750MB runnin on Ubuntu 8.04 LTS on a vmware server 1.0.7.
I've already moved all the var/article folder to an iscsi storage (I can confirm that there are no performance issues there) and would be great to shrink the db too.
 
Thx Bohuslav ;-)
AleX

Alessio Tosi
Sistemi Informativi
Tel. +39 0290026.812
Mob. +39 3486024492
OKI Systems (Italia) S.p.A.
via Milano 11
20084 Lacchiarella MI - Italy

View Alessio Tosi's LinkedIn profileView Alessio Tosi's profile 

Any opinions expressed in this email are those of the individual and not
necessarily of the Company. This email and any files transmitted with it,
including replies and forwarded copies (which may contain alterations)
subsequently transmitted from the Company are confidential and solely for
the use of the intended recipient. It may contain material protected by
legal privilege. If you are not the intended recipient or the person
responsible for delivering to the intended recipient, be advised that you
have received this email in error and that any use is strictly prohibited.
Please notify the sender immediately of the error and delete any copies of
this message

 

Warning: The Company cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments.

 

From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of CARNINO Daniele (FIAT SERVICES)
Sent: Tuesday, September 30, 2008 11:40 AM
To: User questions and discussions about OTRS.
Subject: [otrs] R: Exporting attachments from DB to FS

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