On Fri, Jan 20, 2006 at 09:28:58PM -0800, Joe Votour wrote:
>
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Behalf Of
> > David A. De Graaf
> > Sent: Friday, January 20, 2006 6:39 PM
> > To: mythtv-users@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
[EMAIL PROTECTED] www.datix.us
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
