Page 1 of 1

Reading DB files

PostPosted: Sat Sep 29, 2012 5:10 am
by greenythebeast
I know this may be an odd request but it would be a lifesaver for me. One of my hard drives died last night and I'd like to get a list of stuff that was on it. Is it possible to read the Serviio db files somehow and figure out what was on the drive? It was a drive full of media files and they were all in Serviio's library. Thanks for any help!

Re: Reading DB files

PostPosted: Sat Sep 29, 2012 10:16 am
by zip
Install a SQL client that supports Apache Derby database and point it to the c:\Program Files\Serviio\lib\db database in embedded mode. Example here: http://db.apache.org/derby/integrate/SQ ... Derby.html

Re: Reading DB files

PostPosted: Sat Sep 29, 2012 1:17 pm
by greenythebeast
Here's a screenshot of what I have going so far:

Image

So, I seem to have something working, but I have no clue where I can find a list of items that are in the library. Any tips?

Re: Reading DB files

PostPosted: Sun Sep 30, 2012 12:03 pm
by zip
Under media_item table.

Re: Reading DB files

PostPosted: Sun Sep 30, 2012 5:56 pm
by greenythebeast
Image

Does it take time to load all of the items? Otherwise there's nothing there :/

Re: Reading DB files

PostPosted: Mon Oct 01, 2012 9:45 am
by zip
Is your Serviio installed on a different machine and still runnng? If yes it might have removed everything from the library as it cannot access it anymore.

Alternatively you could check the log file, it should list of added files, unless it's been some time and the log entries have been replaced by newer ones.