CODEWITHSUNDEEP
mysqllinuxbash
recursive_acronym
recursive_acronym

Reputation: 3031

Redirect mysqldump to a file from a bash script

From the command line I can do a dump and redirect it to a file without any issue.

sql=mysql_dump.sql
run_sql="mysqldump -u root -p scope_import > $sql"
$run_sql

When I run it from this script it gives an error: Not such table '>' so its no seeing the > as a redirect rather a table name.

Upvotes: 1

Views: 1107

Answers (2)

Eugen Rieck
Eugen Rieck

Reputation: 65264

Wrong quotes

sql=mysql_dump.sql
run_sql="mysqldump -u root -p scope_import"
$run_sql > "$sql"

Upvotes: 2

NPE
NPE

Reputation: 500227

How about simply:

sql=mysql_dump.sql
mysqldump -u root -p scope_import > $sql

(I hope I haven't misunderstood your question).

Upvotes: 3

Related Questions