MySQL cleanup

I'd like to echo request #2 if it's reasonable to implement.


I'm pretty sure that you could drop the attachment file
records without hosing things, but you might want the final
word from Mr. Alsdorf.

Jim

-----Original Message-----
From: Andrew Hankinson [mailto:andrew.hankinsongmail.com]
Sent: Tuesday, October 03, 2006 11:56 AM
To: eventum-userslists.mysql.com
Subject: MySQL cleanup


Hi,

My hosting provider allows each database on its system to
only be  
250MB.  Since Eventum keeps all attachments in the database
itself,  
this is starting to become a problem.  I have two questions
regarding  
this:

1) I want to keep a copy of the text of e-mails sent, but
discard the  
attachments.  Is it ok to simply drop those records from the
database  
in the issue_attachment_file table, or will I be screwing it
up  
somewhere else?

2) As a feature request, could it be a configuration option
to keep  
file attachments in a data directory on the server, instead
of  
directly in the database?

Many thanks,

Andrew

-- 
Eventum Users Mailing List
For list archives: http://lists.mys
ql.com/eventum-users
To unsubscribe:    http://lists.mysql.com/eventum-users?unsub=james.baker
citigroup.com


-- 
Eventum Users Mailing List
For list archives: http://lists.mys
ql.com/eventum-users
To unsubscribe:    http:
//lists.mysql.com/eventum-users?unsub=bondyahoo.com

Hi,

Regarding #2, I find it really convenient to have almost
everything in
the DB - administration becomes very very simple coupled
with greater
Data Integrity - no chance of File Attachments getting
deleted from the
Data Directory for "some unknown reasons".

Probably, the setting of whether to have file attachments in
the DB or
in a Data Directory itself could be made configurable.

Thanks and rgds,
Watson

-----Original Message-----
From: Baker, James [CIB-IT] [mailto:james.bakercitigroup.com] 
Sent: Wed, 04-Oct-2006 18:45
To: Andrew Hankinson; eventum-userslists.mysql.com
Subject: RE: MySQL cleanup

I'd like to echo request #2 if it's reasonable to implement.


I'm pretty sure that you could drop the attachment file
records without
hosing things, but you might want the final word from Mr.
Alsdorf.

Jim

-----Original Message-----
From: Andrew Hankinson [mailto:andrew.hankinsongmail.com]
Sent: Tuesday, October 03, 2006 11:56 AM
To: eventum-userslists.mysql.com
Subject: MySQL cleanup


Hi,

My hosting provider allows each database on its system to
only be  
250MB.  Since Eventum keeps all attachments in the database
itself,  
this is starting to become a problem.  I have two questions
regarding  
this:

1) I want to keep a copy of the text of e-mails sent, but
discard the  
attachments.  Is it ok to simply drop those records from the
database  
in the issue_attachment_file table, or will I be screwing it
up  
somewhere else?

2) As a feature request, could it be a configuration option
to keep  
file attachments in a data directory on the server, instead
of  
directly in the database?

Many thanks,

Andrew

-- 
Eventum Users Mailing List
For list archives: http://lists.mys
ql.com/eventum-users
To unsubscribe:
http://lists.mysql.com/eventum-users?unsub=james.baker
citigroup.com


-- 
Eventum Users Mailing List
For list archives: http://lists.mys
ql.com/eventum-users
To unsubscribe:
http://lists.mysql.com/eventum-users?unsub=M.Srivathsansiemens.com


-- 
Eventum Users Mailing List
For list archives: http://lists.mys
ql.com/eventum-users
To unsubscribe:    http:
//lists.mysql.com/eventum-users?unsub=bondyahoo.com