where are documents stored?

[jsbenson]

Hi, I have some documents stored in SugarCRM Open Source 4.5.1d. I'm also using the MySQL Administrator GUI to dump the CRM database to my PC for backup.

When I look through the SQL dump, I can see the documents table statements, but I don't see the individual document data so I'm wondering if Sugar just stashes documents in a directory outside MySQL so I need to explicitly back them up separately.

Do I? And, if so, are there any other bits and pieces of my Sugar data (as distinct from Sugar application files) that I need to back up besides the Documents and the MySQL database?

(By the way, documents attached to outgoing emails do show up in the SQL dump as email attachments in the emails table.)

[Angel]

The documents are stored in the <sugar root>/custom/uploads folder.

[gunni]

Sorry to correct you, but they are stored in <sugarroot>/cache/uploads
There they are stored with the name is the sugar-id for the document.

[jsbenson]

I did find the documents in <sugar root>/cache/uploads, not in the other directory, maybe because I'm running 4.5.1d.

I'm worried, however, by the directory name "cache". Doesn't that imply that they could be wiped out automatically at some point? Or does this cache directory contain items that persist until some overt manual action?

[Angel]

Gunni, thanks. Sorry for the mistake on my part.

Jsbenson, they'll remain in the directory barring any manual action that causes them to be deleted.

[al3]

Gunni, thanks. Sorry for the mistake on my part.

Jsbenson, they'll remain in the directory barring any manual action that causes them to be deleted.

Define 'manual action.' I think you mean 'outside' of CRM?

I uploaded an "Notes" pdf file attachment. It is in the cache/uploads folder (by ID number.)

I then deleted it via CRM. However, when I go back to look in the folder it is still there. That's not good. Looks like CRM might take the link to the ID out of the database but does not purge the actual (pdf) file?

Do we have to purge 'manually' via a file manager or FTP (if on a remote server)?

Thanks,
Al

[jsbenson]

Leaving the data around while simply setting a flag to indicate that a logical deletion has occurred would seem to fit in with the general Sugar idea of being able to undelete and retrieve old stuff if necessary.

Of course, this has some consequences for security, since you're leaving a data trace.

[aleksserbia]

Hi folks,
may i ask something?
i think i am running sugar 4.5.1, according to config.php, so in my table documents i have documents that i entered ,so are you talking about this cash\.. only when you make sql dump because i cant find any upload folder.
Thanks in advance
Aleks

[mittapallikiran]

can someone tell me

are the documents store in database if so
where are documents stored in the database?

[kinshibuya]

Hi documents are not stored at the database, on the previw posts you can find the path.
To locate a document, you can find it on DB and get it´s content. hten you can go on the file system and get your file. If you need some help with selects just say so