May be db files are not as MySQL user. Check owner ship for the files of the
It should be mysql user ownership.
On Tue, Jan 18, 2011 at 6:36 AM, Peng Yu <pengyu.ut@stripped> wrote:
> 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)
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1