[mythtv-users] Wrong Time on Progress Bar
ray cielencki
mythtv at rayslinky.com
Sat Oct 25 20:01:44 EDT 2003
>Yep, this fixed it, figured out yesterday. A couple questions though . . .
>
>Why is it usually this database that goes bad?
>
>Is there any reason not to run mysqlcheck -r daily as part of a
>self-maintainence routine ??
>
>Thanks,
>
>-Eric
this table is HUGE. mine has 450,000+ rows claiming 27MB (with
relatively few recordings). probability says that it is the most
likely to see corruption if mysqld isn't shutdown properly. the next
biggest table is the program table, holding all the guide data for
the week - mine has 40,000 rows (5MB).
while mysqlcheck shouldn't cause any problems if run as a part of a
self-maintenance routine, i take the attitude of "if it ain't broke,
don't fix it". having said this, i do regularly back up to another
machine with mysqldump and keep around a weeks worth of dumps and
update logs to recreate tables should anything go drastically wrong.
/rayc
More information about the mythtv-users
mailing list