CODEWITHSUNDEEP
command-linepathmysql
okancelik
okancelik

Reputation: 367

Mysqldump command not found

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?

Upvotes: 26

Views: 117953

Answers (8)

Kmaj
Kmaj

Reputation: 91

I just did the following steps and that fixed the issue for me!

1- sudo nano ~/.zshrc 2- Added the following to the file: {export PATH=$PATH:/usr/local/mysql/bin} 3- restart your terminal (not sure this is needed, but I did it to make sure!)

Hope this will fix someone's issue!

Upvotes: 0

biniam
biniam

Reputation: 8199

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

Upvotes: 17

Farhan Ali
Farhan Ali

Reputation: 230

You are actually trying using git bash, please try CMD xampp/mysql/bin then run

mysqldump -u root -p DbName> name_to_downlaod.sql

Upvotes: 0

nealous3
nealous3

Reputation: 742

For mac users, look into /usr/local/, this is most likely where mysql is installed. There may be two installations. I chose the one without the version number in the name.

You need to add the path of your mysql installation to your bash profile by adding export PATH=$PATH:/usr/local/mysql/bin to ~/.bash_profile. Can try running PATH=$PATH:/usr/local/mysql/bin if adding export to ~/.bash_profile doesn't work.

Upvotes: 2

IMc
IMc

Reputation: 61

My solution: (On windows)
1, Right click to your computer ==> Properties ==> Advanced system settings ==> on tabs "Advanced" click Environments Variables ==> on System variables find "Path" and click "Edit".
2, Finally, you copy your bin folder of your mysql to that.
Ex: D:\LEARN\wamp64\bin\mysql\mysql5.7.14\bin
3, Restart cmd and try your command again.
Nice..

Upvotes: 5

Andres Ramos
Andres Ramos

Reputation: 330

For OS X and MAMP (localhost) open Terminal and run

sudo nano ~/.bash_profile

Add the following code (make sure to change the -uroot -proot by the username and password you have for mysql):

alias mysqldump='/Applications/MAMP/Library/bin/mysqldump --host=localhost -uroot -proot'

Once added, Press Ctrl + O to save then Ctrl X to leave the editor, now run on the terminal

mysqldump dbname > dump_name.sql

That worked perfectly for me.

Upvotes: 8

Tass
Tass

Reputation: 1628

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

Upvotes: 17

Luke Peterson
Luke Peterson

Reputation: 8861

You probably don't have the MySQL /bin folder on your PATH. Change to your mysql /bin folder and try the command again.

Upvotes: 11

Related Questions