[mythtv-users] TV sched is wrong; how to fix it?

[David A. De Graaf]

On Fri, Jan 20, 2006 at 09:28:58PM -0800, Joe Votour wrote:
> 
> > 
> > -----Original Message-----
> > From: mythtv-users-bounces at mythtv.org
> > [mailto:mythtv-users-bounces at mythtv.org]On Behalf Of
> > David A. De Graaf
> > Sent: Friday, January 20, 2006 6:39 PM
> > To: mythtv-users at mythtv.org
> > Subject: [mythtv-users] TV sched is wrong; how to
> > fix it?
> > 
> > 
> > Somehow, my TV schedule database got some wrong
> > info.  Possibly it
> > happened as a consequence of a recent power failure;
> > I don't know.
> > 
> > I'd like to delete just the schedule data and rerun
> > mythfilldatatbase,
> > but I don't see how to do this selective deletion.
> > How do I delete and renew the schedule data from the
> > mysql database?
> > Any advice is welcome.
> > 
> > 
> > --
> > 	David A. De Graaf    DATIX, Inc.    Hendersonville,
> > 
> 
> Please forgive the numbered bullets, but this doesn't
> really fit into proper paragraphs.
> 1. Check that Zap2It didn't change your channel
> numbers.  If they did, then you'll need to reset them.
> 2. You can delete the schedule information by running
> the SQL command "delete from program;".
> 3. To check your channels in the database and compare
> them against Zap2It, or what you think they should be,
> you can do the SQL command, "select * from channel;".
> 4. After deleting the schedule information (step 2),
> you can re-run mythfilldatabase, and it should
> (hopefully) pull down the correct info.
> 
> -- Joe
> 

Thank you Joe Votour.  Your solution of running "delete from program;"
followed by "mythfilldatabase" fixed my schedule database.

I need to learn more of these mysql commands.  They're not exactly
obvious...

-- 
	David A. De Graaf    DATIX, Inc.    Hendersonville, NC
	dad at datix.2y.net     www.datix.us