[Gofriends] Error uploading MySQL dump

[Gail Binkley]

According to the GO schema documentation 
(http://www.geneontology.org/GO.database.schema.shtml#go-meta.table.term-synonym) 
the term_synonym column is a VARCHAR(996), not a Text or BLOB.  The reason 
why you are getting error 1170 is that Mysql doesn't support a text or 
blob column in an index.  The solution is to give the term_synonym column 
a size limit then try your import.

Be sure you have the latest version of the GO schema and it is always good 
to use the latest stable version of Mysql (which is 5.0.67).

Gail Binkley
Stanford

On Tue, 9 Sep 2008, Benjamin Hitz wrote:

>
> Our DBA recommends upgrading to MySQL 5+.  Please let us know if this doesn't 
> fix the problem.
>
> Ben
>
> On Sep 9, 2008, at 5:55 AM, David Martin wrote:
>
>> Trying to import the term_synonym table (term_synonym.sql) I get the 
>> following MySQL error:
>> 
>> ERROR 1170 (42000) at line 16: BLOB/TEXT column 'term_synonym' used in key 
>> specification without a key length
>> 
>> MySQL version is 4.1.20-log
>> 
>> ..d
>> 
>> _______________________________________________
>> Gofriends mailing list
>> Gofriends at geneontology.org
>> http://fafner.stanford.edu/mailman/listinfo/gofriends
>
> --
> Ben Hitz
> Senior Scientific Programmer ** Saccharomyces Genome Database ** GO Consortium
> Stanford University ** hitz at genome.stanford.edu
>
>
>
> _______________________________________________
> Gofriends mailing list
> Gofriends at geneontology.org
> http://fafner.stanford.edu/mailman/listinfo/gofriends