[BioSQL-l] BioSQL Help

[Hilmar Lapp]

On Jul 25, 2013, at 10:24 AM, Peter Cock wrote:

> On Thursday, July 25, 2013, Tomlin, Joshua James wrote:
> 
>> Hi, I'm on Mac os x 10.7.5 and am trying to setup biosql. I believe I have
>> correctly installed MySQL, BioPython, and have the biosql-1.0.1 directory
>> from the biosql wiki downloads page. I've tried following the instruction
>> in the INSTALL text doc and all seemed to be going well untill I tried to
>> load the schema to a database I created just to test.
>> The issue I'm experiencing is when I run the "mysql -u root biosql <
>> biosqldb-mysql.sql" command in Terminal I get an error that says "ERROR
>> 1064 (42000) at line 49: You have an error in your SQL syntax; check the
>> manual that corresponds to your MySQL server version for the right syntax
>> to use near 'TYPE=INNODB' at line 8"
>> 
>> Any ideas?
>> Thanks.
>> 
>> 
> Which version of MySQL do you have?
> 
> Which version of the BioSQL schema do you have? The latest release or the
> latest from GitHub?
> 
> My guess is you need this update,
> https://github.com/biosql/biosql/commit/f6697005c35976bb8744e9579390910f73e2945b
> 
> Hilmar, can we do a release soon to ship this fix?

Yes, we should indeed absolutely do this.

	-hilmar
-- 
===========================================================
: Hilmar Lapp -:- Durham, NC -:- hlapp at drycafe dot net :
===========================================================