Applescript and Shell Script to call MySql - Easy one I think. but...

Scripting Forums AppleScript | Mac OS X
#1

I need to use a shell script against a MySql DB from applescript.

I have the code that I need to run the script, however when I do I get the following error.

/usr/local/mysql/bin/mysql: No such file or directory

I know there is something I have to install for the shell to be able to call the MySql and I thought it was a MySql driver. I used to have it installed, but since I am on a new machine I have forgotten what I need to do to make it work. I downloaded one and installed it, but still got the same error. Can anyone help me?

#2

$ ls -la /usr/local/mysql/bin/mysql

Results?

#3

here are the instructions from Apple, if you think you missed something:

http://developer.apple.com/internet/opensource/osdb.html

cheers.

EDITED: to make this more clear.