topic Re: Database document storage location in Alfresco Archive

Database document storage location

opusensemble — Fri, 10 Jan 2014 20:43:16 GMT

4 questions: 1) In which database table does alfresco store documents? 2) What is the SQL data storage type used? 3) What is the maximum filesize one can upload?4) If I dump alfresco database and later import it to a same version of the same alfresco installation, will that be enough to have everyth

Re: Database document storage location

jpotts — Fri, 10 Jan 2014 21:02:27 GMT

<blockquote>1) In which database table does alfresco store documents? </blockquote>
Documents are never stored in the database. They are stored in the file system.

<blockquote>2) What is the SQL data storage type used? </blockquote>
That's up to you. We support a variety of relational databases. The binary installer ships with PostgreSQL but MySQL is the most popular choice. Of course proprietary alternatives like Oracle and MS SQL Server are also supported.

<blockquote>3) What is the maximum filesize one can upload?</blockquote>
There is no theoretical maximum file size. The file size is limited only by your physical file storage solution.

<blockquote>4) If I dump alfresco database and later import it to a same version of the same alfresco installation, will that be enough to have everything working as before?</blockquote>
You must dump the database and also back up the file system where the files and full-text indexes are stored. Together this forms what you need to successfully recover or migrate the entire content repository.

Jeff

Re: Database document storage location

tharun — Tue, 13 Oct 2015 07:40:09 GMT

1) In which database table does alfresco store tag or references of documents uploaded using Afresco dashboard ?
2) Where sql files of Alfresco will be stored ?

Re: Database document storage location

imed — Thu, 10 Mar 2016 10:56:55 GMT

is it possible to store database content and schema in alfresco like i store files docs…
thank you