did u check if there any firewall settings, forbidding you to create files, check if " SELinux is disabled"
On Mon, Sep 10, 2012 at 6:08 PM, Machiel Richards - Gmail < machiel.richa...@gmail.com> wrote: > Hi > > > at the moment this does not really matter to us. > > we have even tried to create a temp table with only one field in order > to insert one row for testing, but we are currently not able to create any > temporary tables whatsoever as even the simplest form of table still gives > the same error. > > Regards > > > > On 09/10/2012 02:33 PM, Ananda Kumar wrote: > > this temp table will hold how many rows, what would be its size. > > On Mon, Sep 10, 2012 at 5:03 PM, Machiel Richards - Gmail < > machiel.richa...@gmail.com> wrote: > >> 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? >>> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql >> >> > >