[mythtv-users] Can't change channel data with Mythweb anymore

Bob Sully rcs at malibyte.net
Wed May 28 22:55:09 UTC 2008


Ian Clark wrote:
> Hi Bob,
>
> I run optimize_mythdb.pl as a cron job daily; ran it again just now,
>> everything's OK.
>>
>
>  It may be worth explicitly checking the tables using mysql-admin (or is
> it
> mysqladmin, whichever one's the graphical tool.), it appears that
> optimize_mythdb.pl may be missing tables. (See the post from John Taggart
> in
> '[mythtv-users] Mythfilldatabase running every 5 minutes' thread.)
>
> I've had a couple of DB corruptions (I'm very new to myth/linux, so have
> been fiddling a lot.) and I'm sure I had to explicitly repair table (in
> the
> graphical client) as the check/optimize just wasn't working.
>
> Cheers,
>
> Ian
>

Hi Ian -

I just ran mysqlcheck on the database and it came up clean (except for the
weather tables, which come up with "The storage engine for the table
doesn't support repair".  I still can't save changes through Mythweb.  :-/

Thanks
Bob

-- 
________________________________________
Bob Sully - Simi Valley, California, USA
http://www.malibyte.net
http://www.malibyte.com



More information about the mythtv-users mailing list