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