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