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...@gmail.com> 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=yogeshk...@gmail.com > >
