Bashscripts.org

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
Unfortunately not in my bash script:(



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

Is the $Table variable properly set?
You know it's impossible for us to guess as to what you're trying if you're only pasting 2 lines from something obviously larger.

I'm just guessing because it shouldn't try to use > as the table name, which makes me assume something is missing from the string.

Try doing an echo "$temp" and copy/paste that string that it returns

Best regards
Fredrik Eriksson

Ok, apologies for my useless post..
Lets try again.

The echo returns the perfect line of code.
in fact im copying and pasting it into a shell, which is not so great for an automated bash script

This piece code is enough to recreate the error im having.



ensure to pass in the $DB and $TABLE when invoking the script..

Humm... that's wierd...

Might be something with exec. You don't actually need it since bash will expand the variable to the proper string if executed in this fashion:


If that doesn't work either, try using eval.
http://ss64.com/bash/eval.html

Best regards
Fredrik Eriksson

Eval....

EVAL

I promised my colleague that if he worked it out, he could spend a night with my girlfriend..
Thank god you worked it out HUH

Thanks very much Frederik

Regards

Arenstar