[mythtv-users] "You Haven't Scheduled Any Programs"

[Michael T. Dean]

On 07/22/2008 05:33 PM, Mark Parsons wrote:
> Apologies if this is teaching you to suck eggs, as it were, but it took me
> ages to try and find out how to fix my seemingly identical problem:
>
> $sudo mysqlcheck -umythtv -p mythconverg | more
>
> will prompt for your mythtv password, and will then spool off a list of all
> the tables in the mythconverg database, along with a message saying whether
> it's OK or not.
>
> If any of them are corrupt, use the repair parameter to see if the error can
> be fixed
>
> $sudo mysqlcheck -r -umythtv -p mythconverg | more
>
>   

or, better, run optimize_mythdb.pl (no arguments required).  Then, set
it up in a daily cron job as described in the comments at the top.

Mike