Import old TV recordings to new database? (1 Viewer)

[Rybber]

Hi. I'm using 0.2RC2 + latests CVS. They have upgraded the DB version again.

Is there any way to import the old database into the new one?

I have a lot of old recordings and now they are being shown as UNKNOWN, so now I can't find anything

 

[hwahrmann]

you should have done a "Backup" out of the "TV Channel" section in MP Configuration.
Having done this BEFORE the upgrade allows to reimport them later on.

 

[hwahrmann]

what you could try is using sqlite3.exe to dump the old database and insert it into the new.
Similar thing was done, when the database format changed to version 3.
you could find sqlite3.exe in the database\convert directory.
make sure that the NEW database is empty.
Delete it from the database dir and start MP config. This will re-create it.
Then do from a command prompt:

sqlite3.exe TVDatabaseV21.db3 .dump | sqlite3.exe TVDatabaseV22.db3

This will insert the dumped data into the new database.
It should contain now all your recordings, including your channel definitions etc.

good luck,

Helmut

 

[Rybber]

Okay, thanks.

So, does a backup of the TV channels (channellist.xml) also include the database of recorded programs?

 

[hwahrmann]

So, does a backup of the TV channels (channellist.xml) also include the database of recorded programs?

yes, it does.

 

[Rybber]

Thanks.

I now found out, that I could edit the channellist.xml file and insert my old recordings.

See this post: https://forum.team-mediaportal.com/viewtopic.php?t=13768&highlight=