[BioSQL-l] Prolem with loading bioseqsql scheme

[Pim van Nierop]

Hello all,

I have just started out exploring using bioSQL in combination with PERL
scripting to run a local instance of GenBank on mySQL at my lab. I have
to appologize for my ignorance beforehand, as I do not know much about
mySQL.

I followed the instructions as provided on the BioPerl wiki page on how
to start using bioSQL with bioPerl. Unfortunately, I seem to get stuck
when loading my newly created  database named "bioseqdb" with
"biosqldb-mysql.sql" file.

I use this command:
> mysql -u root -p bioseqdb < c:\biosqldb-mysql.sql

This generates the following error:
ERROR 1005 (HY000) at line 39: Can't create table
'.\bioseqdb\biodatabase.frm' (errno: 121)

I looked on th einternet what the errorcode ERROR 1005 errno: 121 means.
It seems it has something to do with foreign keys, but I have no clue
how to act from here.

Could someone please explain what I am doing wrong?

Oh yeah, I use a windows XP system.

All the best,

Pim

--  
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*- 
*-*-*-*-*-

       Pim van Nierop

       Department of Molecular and Cellular Neurobiology
       Faculty of Earth and Life Sciences
       Vrije Universiteit
       Amsterdam

       Tel. +31 (0)20 5987114
       Fax. +31 (0)20 5987112

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*- 
*-*-*-*-*-

_______________________________________________
Open-Bio-l mailing list
Open-Bio-l at lists.open-bio.org
http://lists.open-bio.org/mailman/listinfo/open-bio-l