<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:verdana,helvetica,sans-serif;font-size:10pt"><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt; margin-left: 40px;"><br><div style="margin-left: 40px;"><br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt; margin-left: 40px;">----- Original Message ----<br>From: R. G. Newbury <newbury@mandamus.org><br>To: Discussion about mythtv <mythtv-users@mythtv.org><br>Sent: Saturday, December 8, 2007 4:03:07 PM<br>Subject: Re: [mythtv-users] Mythfilldatabase temporary tables do not exist (SOLVED)<br><br>...<br>My problem has long since been solved! First visible symptom was a
'file <br> does not exist' from mythfilldatabase. That symptom occurred because <br>mysql could not *create* the file: bad permissions. I created a <br>/tmp/mysql folder and gave it to mysql. I (properly) told mysql to use <br>/tmp/mysql. Problem solved without actually having a sticky bit set but
<br>therefore relying on a 0700 permission mode to stop anything/anybody <br>from deleting mysql's temp files. (And the sticky bit is now set.)<br><br>Geoff<br></div><br></div><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt;">Geoff, how do you set up mysql to use /tmp/mysql? Is it just a setting in /etc/my.cnf?<br></div></div></body></html>