[Open-bio-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

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