[mythtv-users] read only tables

[Ben Hannigan]

It's been a while, but I remember having a problem along these lines.  

I think I resolved it by shutting down my mythbackends and then
repairing all the tables in the mythconverg database.

I used an instance of phpMyAdmin, which I had already setup to connect
to the database, to do the repair command, but, if you don't have that
or equivalent, I believe the SQL code is something like: 
REPAIR TABLE <comma separated list of tablenames>;

After which, I just restarted the mythbackends, and it worked again.

Warning, though, my memory is a bit sketchy on it, so this might be
somewhat off.


On Sun, 2006-10-22 at 00:53 -0400, Robert May wrote:
> Hi,
> I've been getting some errors with mythbackend about some tables being
> read only.  I've run mysqlcheck -p -r -u mythtv mythconverg and came
> out with quite a few errors like this one:
> 
> mythconverg.recordedcredits
> error    : Table 'mythconverg.recordedcredits' is read only
> 
> Does anyone know how I can fix this?
> 
> Thanks,
> Robert
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>