Re: Temporary table creation fails

[Machiel Richards - Gmail]

Hi,
     We confirmed that the /tmp directory permissions is set to 
rwxrwxrwxt and is owned by root , the same as all our other servers.

     There is also about 60Gb of free space on the filesystem where /tmp 
resides.

Regards




On 09/10/2012 01:11 PM, Rik Wasmus wrote:
>> the message "ERROR 1005 (HY000): Can't create table
>> '/tmp/#sql4a27_68eed1_0.frm' (errno: -1)"
> Basics first:
> 1) Is the /tmp directory write & readable for the user mysql runs as?
> 2) Has the /tmp directory enough free space?