Put a .my.cnf file in root's home directory. Make it owned by root and mode 400. Put root's mysql password here, and cron can run the backup, but nobody except root can read the .cnf.
[EMAIL PROTECTED] wrote: >i have mysql in redhat and i would liket o automate the backup process.. > >i would like to use mysqldump without password.. any idea how to do this.. > >thanks for the help.. > >-Antz.... >----------------------------------------------- >This email was brought to you by Foothill.net >http://webmail.foothill.net/user/login.cgi > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
