Database document storage location

[opusensemble]

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 everything working as before?

Thanks

[jpotts]

<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

[imed]

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

[tharun]

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 ?