Re: ERROR 1 (HY000): Can't create/write to file '/var/lib/mysql/#sql_9e1_0.MYI'

[Johan De Meersman]

On Tue, Jan 18, 2011 at 6:24 AM, sushant chawla <sushantchawla2005@stripped
> 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