Re: Hide password when running mysqldump from a batch
This should work for mysqldump just as it does for mysql. What, precisely, do you mean by does not appear to work? Describe what happens. Do you get an error, or unexpected results? If an error, what's the error message? If unexpected results, what do you expect, and what do you get? Are you running mysqldump from the command line, or as a cron job? Michael On Apr 1, 2005, at 10:13 AM, rds wrote: No solution for this? Thanks --- rds [EMAIL PROTECTED] wrote: --- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hide password when running mysqldump from a batch
No solution for this? Thanks --- rds [EMAIL PROTECTED] wrote: --- 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!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hide password when running mysqldump from a batch
--- 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]