From: Garot Conklin Date: September 10 2012 1:55pm Subject: Re: Temporary table creation fails List-Archive: http://lists.mysql.com/mysql/228159 Message-Id: <1347285342.44289.androidMobile@web140502.mail.bf1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1366632884-1499028758-1347285342=:44289" --1366632884-1499028758-1347285342=:44289 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Not to beat the perms to death but /tmp should have the sticky bit set as w= ell... so 1777 not just 0777.=A0 Perhaps hard kill any lingering mysql PIDS= unless this is production and u expect other DB's to be running... if u ha= ve duplicated this DB schema somewhow by mistake and a second or first iden= tical instance is running it is plausable to assume that the other running = instance has locked the file it is using preventing it from being written t= o.=0A=0A=0ASent from Yahoo! Mail on Android=0A=0A --1366632884-1499028758-1347285342=:44289--