Howto? Transitioning attachments from database to "files" directory

dschargel

I am concerned about the database size, especially now that I am attaching files to a number of Tickets. I am also concerned about the (lack of) speed when getting these files out of the database. So...I would like to transition from using the "files" directory for attachments rather than storing them in the database.

Any thoughts about how to move from our current "database attachments" to "file attachments"?

David

supportskins · 19-05-2008, 05:44 AM

I do not believe you transit the existing files from database to the files directory. However you can change the software settings to now store any files or attachments into the 'files' directory.

craigbrass · 19-05-2008, 08:19 AM

I really hope this becomes a feature of V4. A migration tool to move attachments between the two.

supportskins · 19-05-2008, 08:31 AM

Quote:

Originally Posted by craigbrass

I really hope this becomes a feature of V4. A migration tool to move attachments between the two.

Indeed would be very useful

AndyHCPS · 05:42 PM

Agreed, I think this is a very needed feature! I have added this as a feature request: Transitioning attachments from database to "files" directory

As database size increases, causing difficulties for restoring backups.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Attachment Storage - Database or Files Directory	markh	SupportSuite, eSupport and LiveResponse	5	17-07-2007 01:02 PM
eSupport - storage of attachments - database vs files directory - Your experience?	richm	SupportSuite, eSupport and LiveResponse	3	25-04-2007 03:02 PM
Database Stored Attachments	johnham	Wont Implement / Already Implemented	0	03-10-2006 11:11 PM
eSupport v2.2 Stable Released	Varun Shoor	News and Announcements	3	23-06-2004 11:39 PM
eSupport v2.2 RC2 Released	Varun Shoor	Technical Chat	1	11-06-2004 10:24 PM

craigbrass Offline Senior Member Posts: 4,947 Join Date: Jun 2005 Location: Cumbria, UK SupportSuite Owned License	19-05-2008, 08:19 AM I really hope this becomes a feature of V4. A migration tool to move attachments between the two. Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

AndyHCPS Offline New Member Posts: 27 Join Date: Jul 2007 SupportSuite Owned License	06-06-2008, 05:23 PM Agreed, I think this is a very needed feature! I have added this as a feature request: Transitioning attachments from database to "files" directory As database size increases, causing difficulties for restoring backups. Last edited by AndyHCPS : 06-06-2008 at 05:42 PM.