From: Jan Steinman
Date: December 31 2011 10:53pm
Subject: Re: why does basic MySQLdump on db table fail with "Permission denied", or else it creates a zero KB file
List-Archive: http://lists.mysql.com/mysql/226532
Message-Id: <6F2E6997-617A-452D-86C1-8BDE7042C9D8@Bytesmiths.com>
MIME-Version: 1.0 (Apple Message framework v1084)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

>> So then I try (in Mac OS X Terminal, while logged in as me (not =
root)):
>> mysqldump -uroot -p myDBname myTableName > ~/myTestDumpedTable.sql
>> ...and again it produces:
>> sh: mysqldump: command not found..
>=20
> that is because Mac OSX is missing a package-managment and so you need
> a little knowledge about your OS to fix the PATH or you have to use
> full-qualified calls or configure/install your software to locations.

How did you get your copy of MySQL?

If you're using MacOS X Server, it should be in /usr/bin, which should =
be in your default $PATH, or else you couldn't do ANYTHING, including =
"ls."

And for the record, there are at least two excellent package managers =
available for Mac OS, and either MacPorts or Fink should append the =
proper path to their binaries to the $PATH variable so they can be =
found. (Although you need to log out and log back in to have your =
shell's .rc file executed.)

Or else you built from source, in which case, you should know how to fix =
your $PATH.

What does "locate mysqldump" tell you? How about "echo $PATH"?

----------------
A gentleman of our days is one who has money enough to do what every =
fool would do if he could afford it: that is, consume without producing. =
-- George Bernard Shaw
:::: Jan Steinman, EcoReality Co-op ::::