BioSQL Installation in MySQL on Mac

[steveymac2k2]

Hi,

 

I'm trying to load a schema for  biosql.

 

I have created a database called "biosql" in MySQL, but i'm trying to load the biosql-schema/sql in MySQL with the command:

 

>mysql -u root biosql < biosqldb-mysql.sql

 

The "biosqldb-mysql.sql file is currently located on my mac in:

/Users/stevey_mac2k2/Desktop/ExerciseTwo/biosql-1.0.1/sql

 

My MySQL is currently saved in:

usr/local/mysql-5.1.35-osx10.5-x86/bin

 

 

I have created a .profile for my mysql commands with the script:

 

export PATH=/usr/local/mysql-5.1.35-osx10.5-x86/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin:$PATH

 

i try the command:

 

bash-3.2# mysql -u root biosql < biosqldb-mysql.sql

bash: mysql: command not found

 

Any help would be greatly appreciated.

 

Thanks!

 

 

[fenway]

This is definitely a *nix issue, not a mysql issue... clearly, it's not in your path.