mysqldump usage in bash

[Arenstar]

Hello everyone..

Im running into quite a large problem in my bash script, I cannot use
mysqldump in bash as i require.

The following code is in my script, and if i run it direct in command line
or by PHP, it works :-O
Unfortunately not in my bash script:(

Code: Select all
    temp="mysqldump -h $DBSource -u $USER -p$PASS $DB $TABLE --where='$Field
> $VarStart  AND $Field < $VarEnd' > $TABLE$DumpName"
    exec $temp



The error recieved is:
mysqldump: Couldn't find table: ">"

The syntax of mysqldump specifies i must use ' ' for the where flag, i have
tried escaping them to no avail.. :(

Your help would be extremely useful..
Arenstar
-- 
View this message in context: 
http://www.nabble.com/mysqldump-usage-in-bash-tp25167570p25167570.html
Sent from the Gnu - Bash mailing list archive at Nabble.com.