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!

you can't run the command at the sql prompt, you do need to run it from your shell.

specify the full path to mysql from bash and see if that works.

This means that mysql isn't even being found. It's not in the PATH.

Do the setting and exporting of the PATH on separate lines.


_________________________________
Embedded database systems | raima.com