Hi, If you can afford try changing the tmpdir for mysql. This is a static variable and will require a mysql restart.
thanks 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 >> <mailto:machiel.richards@**gmail.com<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 >> >> >> >