I am struggling to get the bash script to use the password. What I'm doing here is to assign it to a variable..
--snip- MySQLdump_FilePath="/usr/local/mysql/bin/mysqldump" UserId="root" DB_Production="DB_NAME" #Emarket_Production_Filepath=`/home/website/ProductionDB.sql` #Prefix_Production_CmdLine=$MySQLdump_FilePath" -u ${UserId} --password='[EMAIL PROTECTED]' "$DB_Production #$Prefix_Production_CmdLine > /home/website/test.sql 2>&1 --snip- I added the backslash-escape to the $ character 'cause of bash. The password still doesn't work in bash script. I'm not sure if it is because the password then become a string, along with the \.... Beside the password value, does anyone have ever successfully use the bash script to use the password option in a string tag or in a variable tag or something? I welcome suggestions... FletchSOD