Re: mysqldump usage in bash

2009-08-28 Thread Greg Wooledge
On Fri, Aug 28, 2009 at 07:06:52AM -0700, Arenstar wrote: > What effects can eval have? that i am unaware of. In fact ive never used > eval before, it just wasnt neccessary.. > Thank you for your interesting reply > > query="mysqldump -h $DBSource -u rx -p $DB $TABLE --where '$Field > > $

Re: mysqldump usage in bash

2009-08-28 Thread Arenstar
Hello Greg, So im currently using eval, based on the fact that exec/bash does not see the > in the --where clause. (not the redirection) It is currently working, though im open ears to you explaining how this could be a problem. What effects can eval have? that i am unaware of. In fact ive never

Re: mysqldump usage in bash

2009-08-28 Thread Greg Wooledge
On Thu, Aug 27, 2009 at 06:13:38AM -0700, Arenstar wrote: > temp="mysqldump -h $DBSource -u $USER -p$PASS $DB $TABLE --where='$Field > > $VarStart AND $Field < $VarEnd' > $TABLE$DumpName" > exec $temp The obvious problem here is that you want the last ">" to be treated as a redirection op

Re: mysqldump usage in bash

2009-08-28 Thread 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:( > >