topic Re: Database tables for contents and documents/files in Alfresco Archive

Database tables for contents and documents/files

jaka_prana — Wed, 11 Jan 2012 08:28:01 GMT

Hi guys,I was wondering, to which table does Alfresco WCM stores our documents/files and web contents? I need to know because I need to index these files and contents from another web app which is using the WCM repository. And do these tables have a date columns? I need this column to know the last

Re: Database tables for contents and documents/files

pawel_rzeszowsk — Wed, 11 Jan 2012 09:31:36 GMT

Hello jaka_prana,
Alfresco doesn't store content in relational database. Alfresco uses it's own propetriary file system to store it. You can take a look in the folder ALFRESCO_INSTALATION\alf_data\contentstore. It is the place when after default installation content files are stored.
Best Regards,
Pawel Rzeszowski.

Re: Database tables for contents and documents/files

mrogers — Wed, 11 Jan 2012 10:37:56 GMT

The content store is irrelevant.

However the database implementation is private to Alfresco.

There's various APIs available to list files and modification dates.

Re: Database tables for contents and documents/files

sara — Sat, 15 Sep 2012 11:11:38 GMT

Hello,
I have three question:
1.Do the versions of the file is stored in the file system?(alf_data\contentstore)
2.How can I find a specially content versions?
3.How can I get back up from versions of the contents?
Thanks

Re: Database tables for contents and documents/files

mrogers — Sat, 15 Sep 2012 11:51:07 GMT

Could you have a go at rewording
"specially content versions"
"How can I get back up from versions of the contents?"

1.Do the versions of the file is stored in the file system?(alf_data\contentstore)
Database and File system. The implemention should not concern you,

You probably need to use the version service.

Re: Database tables for contents and documents/files

sara — Sun, 16 Sep 2012 10:49:03 GMT

Could you have a go at rewording
"specially content versions"
"How can I get back up from versions of the contents?"

1.Do the versions of the file is stored in the file system?(alf_data\contentstore)
Database and File system. The implemention should not concern you,

You probably need to use the version service.

Thanks for your reply
1.In which directory do versions of folders store?
2.How can I find the version of a specified folder ?
3.How can I back up from versions of folders? I want to move our alfresco in another computer I should be able to back up from current and restore in new one,I did it but there is no versions of folder in new system, that's why I made these question?
thanks in advance

Re: Database tables for contents and documents/files

imed — Wed, 09 Mar 2016 14:41:00 GMT

hey i m just new with alfresco please is there a way to store a database schema and it's content in the repository of alfresco