Hi All,

Sorry for being a newbie, but how can I remove and reinstall MythVideo

I have done this with my xbox frontend, and I assume it is the same, using apt-get. However I don’t seem to have the sources. Can any one tell me what source i should add? And what file do I add it to?

Once I have that, is it just a matter of
#apt-get update
#apt-get remove mythvideo
#apt-get install mythvideo

I need to do this because I have broken my videometadata.MYI table, then following another tutorial I deleted the file. So I would just like to start it again from scratch. This all happened because my backend froze while I was manually adding IMDB numbers.

Would an upgrade fix this problem?

I have been all over the fourm looking for somthing relevent

also what will I lose in the upgrade, as I spent 2 weeks geting my tv card to work, a further week and a half on the IR blaster to control the digi box, and I realy don't think my girlfreind will be happy if I have to take away the tv again!

please please help, point me in the right direction, anything so I at least have some idea of how to fix this without starting all over again, I don't think I could bare that.

Thanks everyone

EDIT - Cecil is right. I'm not sure if there is a god option...

Doubtful... AS the same db is restored. KnoppMyth has not included a seperate mythvideo deb since 0.18.0. If you take a look at the source, they may still have the mythvideo schema you can dump in the db.

_________________
cesman

When the source is open, the possibilities are endless!

I posted a script on here a few days ago that would help...

#!/bin/bash
/usr/loca/bin/mythbackup
cd /myth/backup
grep "INSERT INTO \`record\` " mythconverg.sql > restore.sql
grep "INSERT INTO \`recorded\` " mythconverg.sql >> restore.sql
grep "INSERT INTO \`oldrecorded\` " mythconverg.sql >> restore.sql
grep "INSERT INTO \`recordedmarkup\` " mythconverg.sql >> restore.sql
mysql -u root < /usr/local/share/knoppmyth/drop.sql
mysql -u root < /usr/share/mythtv/sql/mc.sql
/usr/binGlobalSQLTweaker.sh /usr/local/share/knoppmyth/KnoppMyth.sql
/usr/local/bin/MythTV.sql /usr/local/share/knoppmyth/KnoppMyth.sql
mysql -u mythtv -pmythtv mythconverg < /myth/backup/restore.sql

_________________
cesman

When the source is open, the possibilities are endless!

thaks for the advice guys

I gave the script a try without much sucess, and in the end I downloaded RSA30.1 and completly formated hda and started again. 3 hours later, my videos, music, tv, custom ir-blaster, nfs and samba are all set up and running. I was running RSA16 before, and wow what a diffrence, far better set-up everything I did went smothly. 3 weeks it took me last time!! Also my frontend xbox connected no problem. All I have left now it tv listings *sighs" and IMDB numbers (which I was doing last time when it crashed).

Well done everyone, for all the work you put in to this. And I hope I am in a position to give something back very soon