[mythtv-users] !!NoTrans: SQL Error: Table

[Dick Steffens]

On 12/12/2016 03:32 PM, Romain Kang wrote:
> On Mon, Dec 12, 2016 at 03:09:49PM -0800, Dick Steffens wrote:
>>>> All the file permissions in /var/lib/mysql/mythconverg are the same as
>>>> the following:
>>>> -rw-rw---- 1 mysql mysql     9255 Dec  8 07:41 archiveitems.frm
> Dumb question:

There's no such thing as a dumb question. There can be dumb assumptions, 
but follow the rule "Never assume anything. It makes an ass out of u and 
me."

> Did you check the directory itself?

I did not before.

> On my machine, I see:
> drwxr-x--- 2 mysql mysql 20480 Dec 12 10:43 /var/lib/mysql/mythconverg

drwx------  6 mysql         mysql          4096 Dec 11 21:29 mysql


> If the owner got changed to root, mysqld would not have permissions
> to create the replacement for the bad program table.  Your current
> directory should not matter, since the work is getting done by mysqld
> in its workspace.


-- 
Regards,

Dick Steffens