trouble redirecting mysql command output to file in bash script

Question

for some reason, bash script doesn't redirect output of mysql command in following snippet to designated file.

#!/usr/bin/bash

cmd="select * from foo > '/tmp/sample.txt'"
mysql --user=test --password=test <db name> --host=<hostname> --port=<portname> -e "$CMD"

above script redirect output to console instead of file

 #!/usr/bin/bash

    cmd="select * from foo INTO OUTFILE '/tmp/sample.txt' "
    mysql --user=test --password=test <db name> --host=<hostname> --port=<portname> -e "$CMD"

when I replace ">" redirection operator with "INTO OUTFILE", I'm getting Access permission error

Are you trying to save /tmp/sample.txt to your local machine or to the hostname where the MySQL instance is running? — chrisaycock
– chrisaycock, Commented Jan 6, 2011 at 22:13
Please see BashFAQ/050 (avoid putting commands in variables). — Dennis Williamson
– Dennis Williamson, Commented Jan 6, 2011 at 22:42

chrisaycock · Accepted Answer · 2016-01-10 15:32:49Z

5

What if you move the redirection operator (>) out of the quotation marks?

cmd="select * from foo"
mysql --user=test --password=test <db name> --host=<hostname> --port=<portname> -e "$cmd" > /tmp/sample.txt

edited Jan 10, 2016 at 15:32

user5301308

answered Jan 6, 2011 at 22:02

chrisaycock

38.1k15 gold badges94 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

trouble redirecting mysql command output to file in bash script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related