From: Johan De Meersman Date: January 18 2011 2:04pm Subject: Re: ERROR 1 (HY000): Can't create/write to file '/var/lib/mysql/#sql_9e1_0.MYI' List-Archive: http://lists.mysql.com/mysql/224101 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0015174be640e7aed2049a1f5fe8 --0015174be640e7aed2049a1f5fe8 Content-Type: text/plain; charset=ISO-8859-1 On Tue, Jan 18, 2011 at 6:24 AM, sushant chawla wrote: > Make sure the following things: > > > - /tmp folder is having 1777 permissions > - mysql folder is having the ownership from which it is running. Refer > /etc/my.cnf > - Make sure you have space on your MySQL partition > Also, make sure you have room where MySQL puts it's temp files (possibly /tmp or /var/tmp, check "show global variables like '%tmpdir%';"). This may mean that the server couldn't write a temporary sorting file or something similar to disk. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --0015174be640e7aed2049a1f5fe8--