Configure OpenKM to use MySQL database

[Superpan]

Hi again,

as far as I saw OpenKM 6.2.0 by default (with no extra configurations) uses HSQLDB and stores the BLOB of the uploaded files in the path
C:\openkm-6.2.0-community\tomcat\repository\datastore (in my case).

So I want to know how I can use a MySQL database (I will create it now just for OpenKM) to have all the uploaded files there.
What configuration is needed? I got a bit confused with the wiki... can you point out some links or hints to start with??

Thank you in advance and keep on this good job!

[shaardu]

Yeah u can use mysql database to store ! but you need to get the documentation from the site...

[pavila]

Take a look at http://wiki.openkm.com .

[Superpan]

Thank you for the replies!
I read a lot the wiki and the forum and I think that this case http://forum.openkm.com/viewtopic.php?f=4&t=8355 looks like mine, but I am a bit confused. According to the link above if I use MySQL then the files (docs, etc.) will still be located in the repository folder of my system file as it is now? And if I understood right the files will never be in some folder as they are uploaded (eg. Mydocument.doc) but as BLOB? Am I right??
All I want is to have all my files in ONE place and to back up them (and their relations/versions/modifications) every week. So I thought to have all I need (my files and everything OpenKM needs) in a database.Is this possible with the default configuration (HSQLDB) or I need MySQL??
And then what are the folders I should back-up in order to have openkm as it was before in case of a disk crash lets say??

Your answers are important to us!
Thank you for your support..

[jllort]

In both configurations HSQL or MYSQL you'll got datastorege by default in hard disk under tomcat/repository folder ( this is the best configuration, because when document is demanded from UI is not loosing time copying from dbms to disk and then forward data ).
About backup depending if you're on window or linux you got several applications which you can doing incremental backup. I suggest:
1- Stop application
2- Backup database ( if you're on mysql configuration )
3- Incremental backup from /tomcat folder contents
4- start applications

Mysql is good option if your repository will increase on future, better than HSQL ( Is a suggestion )