I'm trying to run BioSQL and load my first database with MySQL:
"Starting BioSQL and loading the first database
You have to first choose the language or project you want to use in
to load your data. You currently have three options: Perl and BioPerl,
Java and BioJava and Python and BioPython. You will need to download
the schema, the same for all three languages, and the supporting modules
for each language. In each case the package is a mixture of generic
modules for database access and then the BioSQL binding code.
The BioSQL schema is distributed separately from the language
bindings. Use the svn checkout from the anonymous server:
svn co svn://code.open-bio.org/biosql/biosql-schema/trunk biosql-schema
Create a database, which we'll call 'biosql', in the data instance:
For MySQL do:
mysqladmin -u root create biosql"
I am going with the perl-Bioperl route. I have MySQL already installed in usr/local/mysql and i'm now wondering how i can use MySQL to create the database 'biosql'.
when i type in:
bash-3.2# mysqladmin -u root create biosql
bash: mysqladmin: command not found
I have been advised to change the $PATH in my .profile... but have no idea where this is, and how to change it to configure it to usr/local/mysql.
Any advice on this would be much appreciated.