(SOLVED) Safe to delete attachments from Filesystem?

Moderator: crythias

Locked
bayerex
Znuny expert
Posts: 164
Joined: 03 Dec 2012, 00:30
Znuny Version: 3.2.7

(SOLVED) Safe to delete attachments from Filesystem?

Post by bayerex »

Hi,

I use 3.1.3 on a Windows server and already I have configured attachments to be stored in the file system. However I would like to delete all attachments over a year old from tickets.

If I write a batch file and have it run from Windows' scheduler is it completely safe to do this? Will it corrupt the ticket in any way when it is surely still refering to an attachment path in the database?

Greetings!
Last edited by bayerex on 05 Dec 2012, 19:08, edited 1 time in total.
Current Production Server (recently switched from Windows)
OTRS 3.2.7 on Ubuntu 12.04LTS 64bit
PHP 5.3.10-1ubuntu3.6
mysql Ver 14.14 Distrib 5.5.31

Previous Production Server:
Windows 2008
MySQL 5.1.51 Community Server
Strawberry Perl 5.12.3.0
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Safe to delete attachments from Filesystem?

Post by jojo »

you can delete the attachments quite safely, you'll might have dead links to attachments in the tickets. You'll also will loose all HTML formattings
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
bayerex
Znuny expert
Posts: 164
Joined: 03 Dec 2012, 00:30
Znuny Version: 3.2.7

Re: Safe to delete attachments from Filesystem?

Post by bayerex »

ok thanks for the info
Current Production Server (recently switched from Windows)
OTRS 3.2.7 on Ubuntu 12.04LTS 64bit
PHP 5.3.10-1ubuntu3.6
mysql Ver 14.14 Distrib 5.5.31

Previous Production Server:
Windows 2008
MySQL 5.1.51 Community Server
Strawberry Perl 5.12.3.0
Locked