[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