You could use one of: 1. .my.cnf with a password set for the client 2. use -p<password> on the command line
Depends on how secure you want it - use the appropriate grant for the user. M -----Original Message----- From: ROry O'Connor [mailto:[EMAIL PROTECTED]] Sent: 20 December 2001 09:36 To: [EMAIL PROTECTED] Subject: mysqldump - basic question this is an absolute newbie question - but when i try to run mysqldump with a cron (like with a shell script) i can't because mysqldump utility stops to ask for a password. how can I either embed the password or set up mysqldump to not ask for one if, for instance, root is running the shell script? thanks, rory --------------------------------------------------------------------- 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
