Re: why does basic MySQLdump on db table fail with "Permission denied", or else it creates a zero KB file

[Reindl Harald]

Am 29.12.2011 19:21, schrieb Govinda:
> Just a side note, that:
> 
> Govind% which mysqldump
> mysqldump: Command not found.
> Govind% which /usr/local/mysql/bin/mysqldump
> /usr/local/mysql/bin/mysqldump
> 
> kind of defeats the purpose of having to know the path in advance in order 
> to use the command to detect the path  ;-)

"/usr/local/mysql/bin/" is nowhere in the path

"which" can only help you if your standard-user has the
directory in his PATH and another user not

in my opinion this is a configure/compile/install-problem
/usr/local/ is intended to have the stahtdard unix-hirarchy
like /usr/loca/bin, /usr/local/share, /usr/local/lib and
normally /usr/local/bin IS in the PATH

so the problem here is that "mysql" has the unix-hirarchy inside
instead directly install into /usr/lcoal/

on the other hand doing this without a package-managment
it would be better over the long to keep it chaind all in
one directory as it is because you can uninstall it with
simply remove the folder

for the hadnful things on my linux-machines where such non-default
locations are existing i usually set symlinks unter /usr/local/bin/
to the binarys, so they are seperated and from the user point
of view in the PATh and all wroks fine

additionally a "ls -l /usr/local/bin/" shows where all the stuff
is physically installed instead haveing all details in mind
or notice them somewhere you forget also :-)



Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc