[mythtv-users] unable to schedule recordings / databbase trashed

[Mike McMullin]

On Thu, 2010-02-25 at 23:27 -0500, Michael T. Dean wrote:
> On 02/25/2010 11:14 PM, greg wrote:
> > Mike McMullin wrote:
> >> On Thu, 2010-02-25 at 18:36 -0500, greg wrote:
> >>> Mike McMullin wrote:
> >>>>   I went through and deleted some recordings in the UI, a few errored
> >>>> saying that the recording could not be deleted as they were no longer
> >>>> there.  Later I went in to add a new recording (Women's Olympic 
> >>>> hockey)
> >>>> and noted that there was just one recording scheduled instead of the
> >>>> over 30, and that I could not add new recordings.
> >>>>   Any idea what happened and how to fix it?
> >>> Try this: mysqlcheck -u root -p  --repair mythconverg
> >>   Thank You!!!!!!!!!!  I did run that, and it correctly updated the
> >> recorded programs.  When I went in a looked at the upcoming, it showed
> >> only one of the over 30, so I went and added an entry to record, and
> >> then went on to another program, but it showed that that one was set to
> >> record, and had not been shown on the upcoming recordings screen.  So I
> >> went to the upcoming recordings screen, and the over 30 had re-appeared.
> > That command has saved me many times..I have it in my notes,just in 
> > case I need it..
> 
> Someone should write a script that runs it and a few other commands to 
> fix up the database and then call it something like optimize_mythdb.pl 
> and put it in the contrib directory.  :)
> 
> (In other words, read the comments at the top of the optimize_mythdb.pl 
> script--the ones which recommend setting the script to run in a daily 
> cron job.)

  Well I'm glad (almost) that I'm learning new things.  I suppose that I
could also automate the database backups that way too, but I know so
little of cron.  Might be time to learn (and maybe a bit pf perl as
well)?