Where is the file store ?

[dnguyen]

Hello,

I just uploaded a file called test123.doc,  is the file stored in the file system or is it store in the DB ?
if the file is stored in the file system then what directory would it be ? and if it's stored in the DB then what table is it in ?

Thanks for answering my question.

[mrogers]

The file will be stored on the filesystem, in the content store below "alf_data".   The name of your file will be changed to a uuid so you won't be able to find your file by name in "alf_data" but it will be there!

The metadata for your file will be stored in the DB.

[dnguyen]

hi Rogers

Thanks for replying to my question. 
Is there a way I can pull out the file ?  My problem right now is I corrupted the lucene index and for some reason It can't connect to the DB any more, I tried to reindex and everything but still not working.  I have several importants documents that I need to have it back, so is there a way i can open it again in the file system ?  I have looked in to alf_data and try to open every single file in there but i didn't see it.

Thank you

[dnguyen]

The file will be stored on the filesystem, in the content store below "alf_data".   The name of your file will be changed to a uuid so you won't be able to find your file by name in "alf_data" but it will be there!

The metadata for your file will be stored in the DB.

———————————————————————————————————————————————————

hi Rogers

Thanks for replying to my question.
Is there a way I can pull out the file ? My problem right now is I corrupted the lucene index and for some reason It can't connect to the DB any more, I tried to reindex and everything but still not working. I have several importants documents that I need to have it back, so is there a way i can open it again in the file system ? I have looked in to alf_data and try to open every single file in there but i didn't see it.

Thank you

[mrogers]

Your files should be below 'alf_data/content store' and then some numeric directories based upon the creation time of your document.    (Unless of course you have configured Alfresco to store files elsewhere by changing the dir.root property.)

When you say "corrupted your lucene index" did your content also get deleted at the same time?  
If the files have been deleted from the filesystem then I'm afraid its time to restore from backup.

[mrogers]

I'm not sure my posting of the private reply worked (I got a timed out message on send).  

You can see the bin files.   That's good, those are your content.   So we are not in the realms of needing to restore from backup.  Good!

The files will have been created by date order so if you know roughly when you added or uploaded yor files that will help narrow down the choice.   Alternatively if you know some of the content you should be able to find likely files by an operating system search command.