Page 1 of 1

Where database files stored ?

PostPosted:Thu Feb 14, 2019 9:51 am
by mamad
Hi guys,
Im using openkm 6.3.6 community edition which hosted on a Debian Linux server
I want to know where database (i mean whole database) store in file system ?
I made a back up from tomcat-8.5.24 folder of server and changed database for some tests
After a couple of changes in database i decided to recover the old database so i replace the tomcat-8.5.24 folder by the old one but the database didn't changed after recovering the old tomcat-8.5.24 folder
It means database don't save inside tomcat-8.5.24 folder
so where did it saved ?

Re: Where database files stored ?

PostPosted:Fri Feb 15, 2019 7:19 pm
by jllort
Files are stored into repository/datastore folder ( non human format ).
If you select a record into OKM_NODE_DOCUMENT_VERSION using the value of the column NDV_UUID you will get the location, for example for value 008edbfd-7198-4541-b08a-4c1f9e7afa3d the location of the file will be repository/datastore/00/8e/db/fd/008edbfd-7198-4541-b08a-4c1f9e7afa3d

Hope it will help you