List:General Discussion« Previous MessageNext Message »
From:sushant chawla Date:January 18 2011 5:24am
Subject:Re: ERROR 1 (HY000): Can't create/write to file '/var/lib/mysql/#sql_9e1_0.MYI'
View as plain text  
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

Regards
Sushant Chawla




On Tue, Jan 18, 2011 at 10:51 AM, Yogesh Kore <yogeshkore@stripped> wrote:

> May be db files are not as MySQL user. Check owner ship for the files of
> the
> table.
> It should be mysql user ownership.
>
> On Tue, Jan 18, 2011 at 6:36 AM, Peng Yu <pengyu.ut@stripped> wrote:
>
> > Hi,
> >
> > I run the following command. But I got the following error. I'm not
> > sure what causes the problem. I have seen the same issue before, but
> > it disappeared even I didn't take any action. Could anybody let me
> > know how to fix the problem?
> >
> > mysql -ugenome -hgenome-mysql.cse.ucsc.edu mm9 -A
> >
> > mysql> select geneName as symbol, name as refSeq, chrom, strand,
> > txStart, txEnd from refFlat group by refSeq having count(*)=1;
> > ERROR 1 (HY000): Can't create/write to file
> > '/var/lib/mysql/#sql_9e1_0.MYI' (Errcode: 13)
> >
> > --
> > Regards,
> > Peng
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
> >
> >
>

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