Hello,
 
We are running OTRS on a Windows box with a 9 Gb of space.  We recently ran into an issue with disk space being near capacity.  We saw that one of the data files, article_attachment.MYD, was over 4 Gb in size.  This file is found in <OTRS disk drive>:\mysql\data\otrs.  We moved this file off the machine in desperation only to discover that the attachments were no longer accompanying the messages being sent from OTRS....duh!
 
So my question is: Since apparently we'll have to bring back article_attachment.MYD, is there any way to edit this file and bring it down to a reasonable size.  Or is there a windows "cron" equivalent that could reduce the size of the file on a nightly basis?
 
Any help understanding this (and other huge MYD files) and how to manage them would be extremely helpful.
 
Thank you,
 
David Buice
ITIL Foundations Certified
EDS - PSIC
7000 Chicago Road
Warren, MI  48092
 
( Phone:+1-586-575-4525
+ mailto:david.buice@eds.com
cell: 248-249-9122