List:General Discussion« Previous MessageNext Message »
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'
View as plain text  
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

Thread
ERROR 1 (HY000): Can't create/write to file '/var/lib/mysql/#sql_9e1_0.MYI'(Errcode: 13)Peng Yu18 Jan
  • Re: ERROR 1 (HY000): Can't create/write to file '/var/lib/mysql/#sql_9e1_0.MYI'(Errcode: 13)Yogesh Kore18 Jan
    • Re: ERROR 1 (HY000): Can't create/write to file '/var/lib/mysql/#sql_9e1_0.MYI'(Errcode: 13)sushant chawla18 Jan
      • Re: ERROR 1 (HY000): Can't create/write to file '/var/lib/mysql/#sql_9e1_0.MYI'(Errcode: 13)Johan De Meersman18 Jan
  • Re: ERROR 1 (HY000): Can't create/write to file '/var/lib/mysql/#sql_9e1_0.MYI'(Errcode: 13)Joerg Bruehe19 Jan