[mythtv-users] Mythfilldatabase temporary tables do not exist (SOLVED)

[R. G. Newbury]

cromworshipper-mythtvlist at yahoo.com wrote:
> 
> 
> ----- 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?
> 

I just added the line 'tmpdir=/tmp/mysql' to the [mysqld] stanza of 
my.cnf, created the /tmp/mysql folder (as root), chown'ed it with '-R 
mysql:mysql *' and then did a service restart mysql (since I'm running 
Fedora...you may have to use the './etc/init.d/mysql' call or something 
else.

At that point I had done nothing otherwise with the permissions of the 
/tmp folder. I have since added the 'sticky' bit (although probably not 
necessary on the mythbox as it only runs mythtv). Permissions are now 
1777 or drwxrwxrwxt for /tmp, and drwxr-xr-x for /tmp/mysql.

You can test where mysql puts temporary tables if you have a Schedules 
Direct setup which caches data...it will go into /tmp/mysql if you have 
it correct.

NOTE: Mysql uses different folders for temp tables, in different distros.
nh
Geoff


Geoff