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

[Peng Yu]

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