HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Delete attachments from closed incidents


#1

Hi,

Our MySQL database is now 178 GB(!). Is there any way of deleting attachments for old closed requests but not delete the actual request? I’ve just switched it to using file storage for attachments but it would be good to free some space.

We have about 40000 incidents in our database.

Cheers,

Steve


#2

Hi Steve,

Yes, as John says currently you’d have to just empty the attachment table. If you’ve moved to file system storage though there’s a script that can move all the files out of the DB for you onto the file system if you like:

http://www.helpspot.com/helpdesk/index.php?pg=kb.page&id=300