Attached Files saved in DB vs folder or etc

[mhonmon23]

Hi All,

I don't know all the advantages of files in DB vs files saved in folder or etc..
Please let me know what you guys preferred and why.

And another thing if you preferred files saved not in DB, is there a possibility or way
to transfer the files in DB to a file server or storage?



Thanks all.

[atrol]

The advantage of DB storage is an easy and consistent backup, an easy setup, no additional possible security problem (you don't need any write file permissions to run MantisBT)
There might be problems when having a lot of large attachments because all attachments are stored in one table. (There are limits depending on database engine and OS filesystem)

The advantage of DISK storage is performance.

To move attachments from DB to DISK:
Run admin/system_utils.php where you will find a link "Move Attachments to Disk"
I never tried myself and don't know if this is working without any problems. Before trying: Make a backup!

[mhonmon23]

Thanks atrol, I will work on this and post the result.