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
Unfortunately not in my bash script:(
temp="mysqldump -h $DBSource -u $USER -p$PASS $DB $TABLE --where='$Field > $VarStart AND $Field < $VarEnd' > $TABLE$DumpName"
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..