[mythtv-users] Help: Upcoming recordings list suddenly blank!

mattjackets mattlist at fastmail.fm
Wed Mar 7 16:26:20 UTC 2007

On Tue, 06 Mar 2007 23:12:34 -0800, "Bruce Markey" <bjm at lvcm.com> said:
> matt wrote:
> ...
> > I've been having database table "crashes" lately, mostly in the
> > 'program' table, but I just repaired the 'recordedseek' table today.
> $ killall mythbackend
> $ killall mythfrontend
> $ mysqlcheck -c -u mythtv -pmythtv mythconverg
> $ mysql -u mythtv -pmythtv mythconverg
> mysql> truncate table program;
> mysql> truncate table programrating;
> mysql> truncate table programgenre;
> mysql> truncate table credits;
> mysql> quit
> $ mythfilldatabase
> $ mysqlcheck -c -u mythtv -pmythtv mythconverg
> $ mysqlcheck -o -u mythtv -pmythtv mythconverg
> $ mythbackend -v schedule
> --  bjm

Thanks for the tips, I'll remember them in the future.  Unfortunately,
they didn't help directly.  But running the backend at the console
(instead of /etc/init.d/mythbackend start) allowed me to see that
/dev/video0 went missing!  Once I got ivtv back up and running, all was
well.  Thanks again for your tips!

Also, I've noticed that mysqlcheck will report a table as 'OK' even when
it's not.  If I check the table using the mysql client with 'check table
program;' (for example) it shows it as not OK/corrupt.  Any idea as to
why this is?  I thought both actions were identical.

  mattlist at fastmail.fm

http://www.fastmail.fm - Access all of your messages and folders
                          wherever you are

More information about the mythtv-users mailing list