How to make MySQL dump file from terminal on Mac?

Question

How to import and export MySQL dump file on a Mac?

Like on Windows, I use this code:

mysqldump -u root -p --databases DBname>d:\ FILENAME.sql

But it does not work on Mac terminal. It produces the following error:

-bash: mysqldump: command not found

What error do you get? – Robert Columbia Jul 30 '16 at 16:05 — Robert Columbia, Jul 30 '16 at 16:05
-bash: mysqldump: command not found – Neeraj Sharma Jul 30 '16 at 16:06 — Neeraj Sharma, Jul 30 '16 at 16:06

score 27 · Accepted Answer · edited May 23 '17 at 11:46

27

The location where mysqldump is installed need to be declared in your $PATH.

If you don't know how to edit your $PATH on macOS, you can refer to this question.

For example, if your mysqldump binary is located in /usr/local/mysql/bin, you can edit your $PATH to:

export PATH=$PATH:/usr/local/mysql/bin

With this modification, you won't have to provide the full path to the mysqldump binary every time and will be able to use your command:

$ mysqldump -u root -p --databases DBname>d:\ FILENAME.sql

edited May 23 '17 at 11:46

Community

answered Jul 30 '16 at 16:37

HiDeoo

2

If you're using MAMP, then the mysqldump location is /Applications/MAMP/Library/bin – Jefrey Sobreira Santos Jan 02 '17 at 16:55
@JefreySobreiraSantos thank you. – MahmouD Skafi Sep 17 '21 at 16:55

score 6 · Answer 2 · answered Jul 30 '16 at 16:34

6

i forget to give path to it the query is

/usr/local/mysql/bin/mysqldump -uroot -p friendstree > friendstree.sql

it worked

answered Jul 30 '16 at 16:34

Neeraj Sharma

2 Answers2