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