Parenthesis in cronjob results in error

Question

I am trying to run the following cronjob and I am getting the following error:

/bin/sh: -c: line 0: syntax error near unexpected token `)'

for the line:

mysqldump --opt -Q -h localhost --user=my_username --password=pass)word db_name | gzip -v9 - > db_backup.sql.gz

How do I properly run this cronjob to prevent issues with characters in the password?

What does the question have to do with ssh? – tink Oct 29 '12 at 19:21 — tink, Oct 29 '12 at 19:21

score 3 · Accepted Answer · answered Oct 29 '12 at 19:10

3

Put the password in single quotes to avoid sh from processing the string. I.E.

--password='pass)word'

answered Oct 29 '12 at 19:10

mdpc

1

Or better yet, put it in a `.my.cnf` file in the appropriate user's home directory with appropriate ownership and permissions. – Ladadadada Oct 29 '12 at 19:24

1 Answers1