Import old TV recordings to new database?

Rybber · 2006-03-15, 08:57

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 · 2006-03-15, 09:16

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 · 2006-03-15, 09:39

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:

Code:

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 · 2006-03-15, 10:01

Okay, thanks.

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

hwahrmann · 2006-03-15, 11:47

Quote:

Originally Posted by Rybber

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

yes, it does.

Rybber · 2006-03-16, 13:46

Thanks.

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

See this post: http://forum.team-mediaportal.com/vi...768&highlight=

2006-03-15, 08:57	#1 (permalink)
Rybber Portal Member Join Date: Oct 2004 Location: Denmark Posts: 166 Thanks: 0 Thanked 0 Times in 0 Posts	Import old TV recordings to new database? 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 __________________ Minigal - a simple, free, good looking, dynamic image gallery! (http://www.minigal.dk)

2006-03-15, 09:39	#3 (permalink)
hwahrmann Development Group Member Join Date: Sep 2004 Location: Vienna, Austria Posts: 2,216 Thanks: 13 Thanked 292 Times in 175 Posts Country:	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: Code: 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

2006-03-15, 10:01	#4 (permalink)
Rybber Portal Member Join Date: Oct 2004 Location: Denmark Posts: 166 Thanks: 0 Thanked 0 Times in 0 Posts	Okay, thanks. So, does a backup of the TV channels (channellist.xml) also include the database of recorded programs? __________________ Minigal - a simple, free, good looking, dynamic image gallery! (http://www.minigal.dk)

2006-03-16, 13:46	#6 (permalink)
Rybber Portal Member Join Date: Oct 2004 Location: Denmark Posts: 166 Thanks: 0 Thanked 0 Times in 0 Posts	Thanks. I now found out, that I could edit the channellist.xml file and insert my old recordings. See this post: http://forum.team-mediaportal.com/vi...768&highlight= __________________ Minigal - a simple, free, good looking, dynamic image gallery! (http://www.minigal.dk)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

2006-03-15, 09:16	#2 (permalink)
hwahrmann Development Group Member Join Date: Sep 2004 Location: Vienna, Austria Posts: 2,216 Thanks: 13 Thanked 292 Times in 175 Posts Country:	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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
(original thread) US/Canadian/Mexico EPG Zap2it Plugin Released	bradsjm	zap2it (discontinued)	513	2007-02-21 15:07
Help with TVServer and client	rick78	Television (MyTV frontend and TV-Server)	8	2006-12-12 19:48
Recordings to movie database	Jetboy	Improvement Suggestions	0	2006-11-28 11:16
0.2.1 and latest svn MyPictures thumbnails broken	gloomyandy	Codecs, External Players	1	2006-10-24 11:01