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

2011-01-19 Thread Joerg Bruehe
-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) Errcode is what mySQL writes for an errno

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

2011-01-18 Thread Johan De Meersman
On Tue, Jan 18, 2011 at 6:24 AM, sushant chawla sushantchawla2...@gmail.com wrote: 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

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

2011-01-17 Thread Peng Yu
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

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

2011-01-17 Thread Yogesh Kore
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

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

2011-01-17 Thread sushant chawla
, 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