From: Marcus Bointon
Date: June 29 2009 9:31am
Subject: Re: Error 1005 with errno -1 on CREATE TEMPORARY TABLE
List-Archive: http://lists.mysql.com/innodb/5
Message-Id: <8B94BFA6-C413-48AA-8A88-3B515AF4E626@synchromedia.co.uk>
MIME-Version: 1.0 (Apple Message framework v935.3)
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit

Answering my own question, for the archives...

I restarted apparmor and temp table creation magically started working  
again. I'm not 100% sure it was that that fixed it (the config was not  
changed and it already gave MySQL write permissions in /tmp), but it  
seems the most likely candidate.

Marcus
-- 
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK resellers of info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/