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 http://www.linkedin.com/in/alessiotosi 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
