| LinHES Forums http://forum.linhes.org/ |
|
| How do I clear all program guide data? http://forum.linhes.org/viewtopic.php?f=6&t=7856 |
Page 1 of 1 |
| Author: | rigga [ Fri Jan 13, 2006 4:36 am ] |
| Post subject: | How do I clear all program guide data? |
I recently changed providers (sky to telewest) and manually cleared what I thought was all the program guide data and reconfigured xmltv to get the new listings, I have started to notice errors in the listings in that the wrong data is being populated therefore I want to clear all guide data and start from scratch. Can anyone confirm the exact tables I need to clear to completely wipe the guide data. Cheers |
|
| Author: | fiete [ Fri Jan 13, 2006 5:09 am ] |
| Post subject: | |
I suppose you are using a grabber? Code: mythfilldatabase --update should perform a non-destructive update for users of grabbers, where no channel info ...Code: mythfilldatabase -h will give the complete info for --update option.
So maybe your problem can be solved using the mythfilldatabase program, avoiding corruption of your database. |
|
| Author: | rigga [ Fri Jan 13, 2006 2:00 pm ] |
| Post subject: | |
I am using the radio times grabber. I take it running mythfilldatabase --update will just delete all the guide data and wont affect any channel data? |
|
| Author: | fiete [ Fri Jan 13, 2006 3:47 pm ] |
| Post subject: | |
I've googled and it turns out, that the option --update will prevent that channels unknown to the mythconverg-database are added to the database. So this won't help you! I will try to delete the guide data from my box and restore them by running mythfilldatabase again (don't tell my wife and kids) 
Meanwhile hoping that some mythtv-knoppmyth-database-guru will answer your question about the tables.. |
|
| Author: | tjc [ Fri Jan 13, 2006 6:25 pm ] |
| Post subject: | |
Run mythtv-setup and answer "yes" to both questions. |
|
| Author: | Darth_tater [ Sat Jan 14, 2006 10:59 am ] |
| Post subject: | |
tjc wrote: Run mythtv-setup and answer "yes" to both questions.
but dont forget to resetup your channel source (the acount name, and paswd) then re run mythfilldatabase |
|
| Author: | rigga [ Sat Jan 14, 2006 11:30 am ] |
| Post subject: | |
Quote: Run mythtv-setup and answer "yes" to both questions.
If I do this it will delete my channels as well, I dont want to have to se my channels up again I just want to delete all guide data as I think something has got messed up as a few channels show as having no data available however I am fairly confident that the xmltv side of it is configured correctly so just wanted to zap all the data and run mythfilldatabase again to see if it fills in the 'blanks' Also Ive noticed that some of the data showing on particular channels is wrong..... 
|
|
| Author: | fiete [ Sat Jan 14, 2006 1:12 pm ] |
| Post subject: | |
I think that the way described by tjc is right. But lets be creative: just deleting some or all rows is triggy, as one won't know how they are related to other tables or files. I just had a look into the XMLTV file and noticed, that all programs are within tags. Programs data start with Code: <programme data data data just more tags and data more lines of data </programme> Maybe one could cheet the mythfilldatabase program by manipulating this file. You could delete everything within these tags <programme... and </programme> including the tags. But maybe the tags are very important and have to stay as: . Code: <programme>
</programme> At the beginning of the xmltv file there are other tags, I would leave them! After preparing this XMLTV file you could run mythfilldatabase with the --file parameter and other parameters. tjc, could this work? It would be fine to find a way to clear just the program guide.. |
|
| Author: | tjc [ Sat Jan 14, 2006 1:39 pm ] |
| Post subject: | |
There is a far simpler way if all you want is the program data: Code: su - mythtv "/usr/bin/mythfilldatabase --refresh-all"
it also takes care of little gotchas like rerunning the scheduler... This is what I use when experimental program guide hacking via SQL scripts goes off the rails, but it's not recommended for regular use. |
|
| Author: | ceenvee703 [ Sat Jan 14, 2006 2:38 pm ] |
| Post subject: | |
tjc: did that version of mythfilldatabase come with a newer version of KnoppMyth? My R5A16 does not seem to have a "refresh-all" option available. I used some MySQL commands to clear my guide info: http://mysettopbox.tv/phpBB2/viewtopic. ... 2887#42887 |
|
| Author: | tjc [ Sat Jan 14, 2006 7:39 pm ] |
| Post subject: | |
ceenvee703 wrote: tjc: did that version of mythfilldatabase come with a newer version of KnoppMyth?
Duh-oh!  Darn, sometime I forget that my version is a bit "forward looking". I don't know when this appeared, I'm running something like R5A22++. I'm pretty sure all it does is purge the data from the program tables. I think the tables that need to be cleared are "program", "credits", "programgenres", and "programrating", although I may have missed one or two.
|
|
| Author: | ihatetivo [ Sat Oct 13, 2007 5:06 pm ] |
| Post subject: | |
tjc wrote: There is a far simpler way if all you want is the program data:
Code: su - mythtv "/usr/bin/mythfilldatabase --refresh-all" it also takes care of little gotchas like rerunning the scheduler... This is what I use when experimental program guide hacking via SQL scripts goes off the rails, but it's not recommended for regular use. That little bit of code is a lifesaver. For some reason at least 10 important channels on my guide were wrong for the next 5 days. (For example the History channel data moved from channel 55 to channel 57 according to the guide data). Strangely, the data was correct at 6 days out and beyond. Anyway, using that code blasted away the errors and filled the database correctly. Sweet! |
|
| Page 1 of 1 | All times are UTC - 6 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|