Backing up "Playback Position"

[Reddwarf]

Whenever I have to start with a fresh database I can easily get my recordings and recurring recordings back from the corresponding .xml files created by npvr when epg is updated, but I will lose the playback position of all watched recordings. Is there a quick method suitable for batch execution to back up this table so I can manually restore it?

[mvallevand]

It's quite easy with the sqlite command line get the pre-compiled binary here http://www.sqlite.org/download.html

To backup

Code:

sqlite3.exe npvr.db3 "select * from playback_position" > playback.txt

and restore into the fresh database

Code:

sqlite3.exe npvr.db3 ".import playback.txt playback_position"

Using the command line tool you can even get fancy and do things like only backing up recent files, restoring directly from a backup of a db3 file etc, but that should be a start for you.

Martin

[Reddwarf]

Thanks Martin. But it should be possible for Sub to include PlaybackPosition in the RecordingBackup.xml?