Mysqldump command not found

Question

I want to export my database and i am using this code:

mysqldump -p -u markazo_b markazo_b > /tmp/file.sql 

But SSH show this error:

-bash: mysqldump: command not found

How i fix this problem?

Answer 1

After reading your conversation, I found the solution (for me, at least). It was a permissions issue.

Issuing which mysqldump in the terminal shows /usr/bin/mysqldump.

When I then issue cd /usr/bin/ and afterward mysqldump I receive the same indications you were seeing: mysqldump: command not found.

Inside /usr/bin I then issued sudo mysqldump and received:

Usage: mysqldump [OPTIONS] database [tables] OR     mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...] OR     mysqldump [OPTIONS] --all-databases [OPTIONS] For more options, use mysqldump --help 

Try that and see if it helps.

Edit: too long, didn't read: sudo mysqldump may work. (May be a permissions issue.)

Answer 2

The solution I found is adding MySql's installation directory to PATH

Steps:

1. Find where MySql is installed
2. Add the bin directory of MySql installation to PATH

(In the terminal),

locate mysqldump  export PATH=$PATH:MY_SQL_INSTALLATION_DIRECTORY/bin 

MY_SQL_INSTALLATION_DIRECTORY is the directory you found by locate mysqldump: Example

export PATH=$PATH:/usr/local/mysql-5.6.23-osx10.8-x86_64/bin