This line should do it (no space after -p)
Prefix_Production_CmdLine="$MySQLdump_FilePath -u ${UserId} -pmy_password
$DB_Production"
_____________________________
Steve Poirier
-----Original Message-----
From: Scott Fletcher [mailto:[EMAIL PROTECTED]
Sent: August 6, 2004 1:24 PM
To: [EMAIL PROTECTED]
Subject: Bash Shell issue with the mysqldump's password.....
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
