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

[greg]

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.)
>
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
Yeah, Thanks Mike.. I do that now,but in the past I was trying to figure 
this all out on my own, and Google found that command for me.. It did 
save me a few times.... When people ask about trashed tables, it's an 
easy cut and paste for me....
Thanks