[mythtv-users] Mythfilldatabase temporary tables do not exist (SOLVED)
cromworshipper-mythtvlist at yahoo.com
cromworshipper-mythtvlist at yahoo.com
Sun Dec 9 09:27:47 UTC 2007
----- Original Message ----
From: R. G. Newbury <newbury at mandamus.org>
To: Discussion about mythtv <mythtv-users at mythtv.org>
Sent: Saturday, December 8, 2007 4:03:07 PM
Subject: Re: [mythtv-users] Mythfilldatabase temporary tables do not exist (SOLVED)
...
My problem has long since been solved! First visible symptom was a
'file
does not exist' from mythfilldatabase. That symptom occurred because
mysql could not *create* the file: bad permissions. I created a
/tmp/mysql folder and gave it to mysql. I (properly) told mysql to use
/tmp/mysql. Problem solved without actually having a sticky bit set but
therefore relying on a 0700 permission mode to stop anything/anybody
from deleting mysql's temp files. (And the sticky bit is now set.)
Geoff
Geoff, how do you set up mysql to use /tmp/mysql? Is it just a setting in /etc/my.cnf?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20071209/bc2b6944/attachment.htm
More information about the mythtv-users
mailing list