npvr.db3 corrupted, can it be repaired?

[NigelG]

I was having problems with one of my DVB-T receivers today and rebooted the machine a number of times to de-install and reinstall the H/W.

Having got the DVB-T tuner working again I seem to have corrupted the NPVR.db3 database... The NPVR Recording Service will not start. If I rename the file I can start the NPVR Recording Service, as a new NPVR.db3 is created.

Having lost the old database I am missing all the timers and .5TB of recordings :-(

Is it possible to identify and fix the old database? It's about 8MB in size. I was able to open on a trial version of a repair application but didn't identify any issues or allow me to 'resave' the file...

Any suggestions gratefully received.

Nigel

[johnsonx42]

Just use your new database and import the recordingbackup.xml and recurringbackup.xml files in Settings->Recording->Import Recordings (same import function for both)

[NigelG]

Hi Johnsonx42,

Thanks for the swift reply. I'l bear it in mind next time...

It looks as if the problem was in moving around the Tuners they became renumbered, and I still suspect the database had some sort of corruption.

I managed to obtain a copy of SQLite Professional and after using the 'Repair' function I also copied the new Tuner configuration from a new database and used it to overwrite the settings that had become confused in the original database. Viola, it all works.

Having said all that your way looks much easier :-)

Thanks again for the instructions.

Nigel