[Open-bio-l] [Fwd: Prolem with loading bioseqsql scheme]

[Pim van Nierop]

I resend this message as I shipped it before my participation to this 
mailing list was confirmed. I am sorry if its a double post.

-------- Original Message --------
Subject: 	Prolem with loading bioseqsql scheme
Date: 	Wed, 05 Jul 2006 15:53:39 +0200
From: 	Pim van Nierop <pim.van.nierop at falw.vu.nl>
To: 	open-bio-l at lists.open-bio.org



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

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




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

      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

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