Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009
    Posts
    1

    Unanswered: BioSQL install - MySQL error (mac)

    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!

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    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.

  3. #3
    Join Date
    Jun 2009
    Posts
    6
    bash: mysql: command not found
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •