you could put the password in your .my.cnf file and change permissions so that only the MySQL user can read the file.
-----Original Message----- From: patrick kuah [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 5:15 AM To: [EMAIL PROTECTED] Subject: mysqldump query Hi guys, I have configure a daily backup for mysql database. the problem is that i need to specifiy the password when using mysql.... mysqldump --all-databases --opt --password=1234567 >testing.sql how can i encypt this --password=1234567 ???? Thanks patrick _________________________________________________________________ Keep track of Singapore & Malaysia stock prices. http://www.msn.com.sg/money/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]