bash 'export' command not working

Hello,

Not sure if this is the right place to put this, but here goes.

Attempting to install jdbc driver so I can connect my java programs to a mysql server.

This is what I have done:

- downloaded mysql-connector-java-5.1.16.zip file from mysql.com.
- Following instructions to install using a bash shell, I typed into my terminal:

sudo export set CLASSPATH=/path/mysql-connector-java-5.1.16-bin.jarCLASSPATH
Password:

This is the error I get:

sudo: export: command not found

export is among my commands on my machine.
I have tried various ways of typing the export command: using no 'sudo' results in nothing I think, just returns to current directory. If that means it was successful I do not no how to check. I did try to run my java program but did not connect successfully.

I am really stuck, lost, where is my 'export' command?
Any questions or advice, please help, Thanks!

export is a bash builtin - it's built into bash. If it doesn't work there's something wrong with bash.
You might be better off putting that command into .bashrc or .bash_profile.
To see if it worked at all type in Terminal: env
You'll get a whole list of stuff.

edit: you shouldn't need to use sudo to put something in your environment, unless it's somehow affecting all users or the system itself.

Thanks Cradom,

It in fact did work, it is in my list of environment variables.

So where do you think would be a good place to store my jar file? Right now it is in my 'downloads' folder.

Thanks again for the pointer!

Pretty much anywhere in your user folder. If you don't have one, make a folder named Apps and put it in there.
Is this a clickable app or a command line app? If command line, you need to put wherever it is in your $PATH.

The problem I am having now is with some java code, getting a class not found exception when trying to load the jdbc driver, I think. I don't really understand the 'Class.forName() method. Read some things on it but still not quite sticking. I posted another thread named 'jdbc driver install location?' that has the java code. The post is under 'operating systems' as well.

I think the problem is the driver files are in the wrong location but maybe it is something else. I do know that the jdbc driver package is not meant to be clickable but that is about it for my knowledge.

Oh, wait, it's a driver? Missed that. Probably should go in the System somewhere then, don't know where.
Some one a whole lot more knowledgeable than me should help with this.

No worries, thanks for your help.

Put it in /etc/bashrc or try sudo -E and do the export in your own environment. That being said - you could just use macports to install
sudo port search jdbc
will show you the available setups - I thought I saw jdbc

Okay, to anyone who wants to know, I figured out my problem. exporting to my classpath worked fine. After that, I placed a copy of the jar file and put it in:

Library/Java/Extensions

Everything works great.
I found some placed the jar file in: Library/Java/Home/lib. Didn't work for me, maybe depends on JDK version you are running or something.

Anyway, thanks for the help!