PDA

View Full Version : Disable channel icons? Generalized database cleanup?



mathog
January 27th, 2009, 01:25 AM
Two quick questions:

1. How does one disable the display of channel icons? (Channel numbers are good enough.)

2. Is there a way to have the Mythtv database do some sort of consistency check / generalized cleanup?

Thanks.

mathog
January 27th, 2009, 05:38 AM
Two quick questions:

1. How does one disable the display of channel icons? (Channel numbers are good enough.)

2. Is there a way to have the Mythtv database do some sort of consistency check / generalized cleanup?

Thanks.

Found 1. It is in Utilities/Setup -> Setup -> Tv Settings -> Program Guide.

Still need an answer to the 2nd one though.

Thanks.

ian dobson
January 27th, 2009, 06:00 AM
Hi,

I run this script once a week or so to cleanup/opimize the db:-

http://www.adspeed.org/2007/01/mysql-shell-script-to-optimize-all.html

I just call it with ./optimize_db.sh --optimizeAll

Regards
Ian Dobson

movieman
January 27th, 2009, 06:05 AM
Mythweb has database optimise and repair options, though I've never used them.