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

[Hilmar Lapp]

Hi Pim, I forwarded your email to biosql-l at lists.open-bio.org, which  
is where the BioSQL discussions take place. I wanted to respond  
yesterday but didn't get to respond to it.

The page to subscribe to biosql-l is at
http://obda.open-bio.org/mailman/listinfo/biosql-l

	-hilmar


On Jul 6, 2006, at 5:19 AM, Pim van Nierop wrote:

> 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
>
> *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*- 
> *-*-*-*-*-*-
>
> _______________________________________________
> Open-Bio-l mailing list
> Open-Bio-l at lists.open-bio.org
> http://lists.open-bio.org/mailman/listinfo/open-bio-l
>

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