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.)