Database document storage location

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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