FAQ  •  Register  •  Login

Reading DB files

<<

greenythebeast

Serviio newbie

Posts: 11

Joined: Fri Feb 24, 2012 10:12 am

Post Sat Sep 29, 2012 5:10 am

Reading DB files

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!
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Sat Sep 29, 2012 10:16 am

Re: Reading DB files

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
<<

greenythebeast

Serviio newbie

Posts: 11

Joined: Fri Feb 24, 2012 10:12 am

Post Sat Sep 29, 2012 1:17 pm

Re: Reading DB files

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?
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Sun Sep 30, 2012 12:03 pm

Re: Reading DB files

Under media_item table.
<<

greenythebeast

Serviio newbie

Posts: 11

Joined: Fri Feb 24, 2012 10:12 am

Post Sun Sep 30, 2012 5:56 pm

Re: Reading DB files

Image

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

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Mon Oct 01, 2012 9:45 am

Re: Reading DB files

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.

Return to Serviio Support & Help

Who is online

Users browsing this forum: No registered users and 81 guests

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by ST Software for PTF.