[mythtv-users] read only tables

Robert May robtmay at gmail.com
Sun Oct 22 15:02:48 UTC 2006


Thanks,  the command I issued should have fixed the tables.  Just that
I hadn't stopped myhtbackend.  I didn't think it was running since it
kept giving me errors when I tried starting it.  Stopping it and
re-running the command did the trick.

Thanks for reminding me to check the little things first,
Robert


On 10/22/06, Ben Hannigan <drduck at usa.net> wrote:
> 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
> >
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>


More information about the mythtv-users mailing list