[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
Bruce,
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.
Thanks,
Matt
--
matt
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