Re[2]: [rt-users] Attachments table of RT's Mysql database

2007-08-08 Thread Boris Lytochkin
Wiki would be enough, but there is a problem in current patch state: it uses special constant string inplace of real content to indicate that file is located out of DB. Right way is to use flag in table. I do not think that changing scheme witch patching is a good idea, that is why this patch

Re: Re[2]: [rt-users] Attachments table of RT's Mysql database

2007-08-08 Thread Jesse Vincent
On Aug 8, 2007, at 5:17 AM, Boris Lytochkin wrote: Wiki would be enough, but there is a problem in current patch state: it uses special constant string inplace of real content to indicate that file is located out of DB. Right way is to use flag in table. I do not think that changing scheme

Re[2]: [rt-users] Attachments table of RT's Mysql database

2007-08-07 Thread Boris Lytochkin
I wrote a patch that allows to store non-text attachments to be stored out of DB - in my case it greatly reduced DB swelling. Just for now it uses constant string in Attachments-Content to indicate that file is written to FS. You will need to specify some variables in RT_Siteconfig.pm:

Re[2]: [rt-users] Attachments table of RT's Mysql database

2007-08-07 Thread Boris Lytochkin
Ken, First, if everything is inside a database, then a simple backup of the database will get everything related to a particular RT instance. Wrong. We _stopped_ backup process of RT database due to LARGE amount data every day. We have no such amount of tape to store DB's everyday backups.

RE: Re[2]: [rt-users] Attachments table of RT's Mysql database

2007-08-07 Thread Justin Brodley
, 2007 6:31 AM To: rt-users@lists.bestpractical.com Subject: Re[2]: [rt-users] Attachments table of RT's Mysql database Ken, First, if everything is inside a database, then a simple backup of the database will get everything related to a particular RT instance. Wrong. We _stopped_ backup process