[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: mysqldump usage in bash
From: |
Ralf Goertz |
Subject: |
Re: mysqldump usage in bash |
Date: |
Fri, 28 Aug 2009 09:00:22 +0200 |
User-agent: |
KNode/0.10.9 |
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