Re: mysqldump usage in bash

[Ralf Goertz]

Arenstar wrote:

> 
> 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: ">"

Don't know if that helps (as it doesn't address the problem directly)
but can't you just use 

--where='$Field between $VarStart AND $VarEnd'

Ralf