> --------------------------------------------------------------- > What you really want to avoid is having the password on the commandline. > File permissions won't matter at all if you end up running a command > that puts your password in the output of 'ps'! Command lines are always > public information. Put the password for mysqldump in the running user's > ~/.my.cnf instead, and tighten the permissions on *that* file. > > [client] > password=Your password goes here
I tried that; it does work with mysql but does not appear to work with mysqldump. Is there a way to supply the password to mysqldump when running dump from a batch scipt and avoid showing it on the command line? Thanks in advance __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]