Hi Maria, The snp132 table was compressed using myisampack, which makes it read-only. You can unpack the table using the myisamchk --unpack command (http://dev.mysql.com/doc/refman/5.0/en/myisamchk.html).
You can download and confirm the size of the internal files of our mysql tables here: ftp://hgdownload.cse.ucsc.edu/mysql/hg19/ I hope this information is helpful. Please feel free to contact the mail list again if you require further assistance. Best, Mary ------------------ Mary Goldman UCSC Bioinformatics Group On 6/28/11 12:35 AM, Maria elena Sana wrote: > Hi UCSC users, > I have a problem with snp132 mysql table. > I can't index the table because it returns me that the table is read-only. > (even if I change all the owner permissions). > Moreover, could you confirm that the dimensions of the file for this table > are 1.8Gb for .MYD, 373Mb for .MYI and 11kb for frm? > Thanx a lot, > Maria Elena > _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
