What is the right syntax for mysql when I want the output file in a specific directory?

Do I have to install mysqldump? This is the message i got when I entered mysqldum into the linux prompt.

The program ‘mysqldump’ is currently not installed.  You can install it by typing:
sudo apt-get install mysql-client-5.0
bash: mysqldump: command not found

mysqldump can also be found inside /usr/local/infobright/bin/. You can try that too.

best regards

Answer to your first question: you can specify the absolute path in the export command, like:

select * into outfile ‘/usr/local/export1.txt’ fields terminated by ‘,’ lines terminated by ‘\n’;

I did not find mysqldump at /usr/local/infobright/bin/. I have no /usr/local/infobright folder

Where did you install infobright? I mentioned the default path which is /usr/local/infobright

In the infobright/bin folder you will find mysqldump.

Try

This will show the mysqldump binary in the bin directory where you installed Infobright.

Then use that explicit path when using MySQL utilities.  Or add that <Infobright>/bin directory to your $PATH.