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

Bruce Markey bjm at lvcm.com
Wed Mar 7 07:12:34 UTC 2007

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

More information about the mythtv-users mailing list