MySQL query doesn't run within cronjob

Question

My problem is that this:

mysql -u root -pmypassword -D cache -e "DELETE FROM cache WHERE job IN('SET', 'UO', 'AV');"

MySQL query doesn't run with the cronjob. I am sure that the cronjob starts itself because rest of the code (mysqldump) is running.

#!/usr/local/bin/bash

mysql -u mysql-u1494 -pmy-password -D cache -e "DELETE FROM cache WHERE job IN('SET', 'UO', 'AV');"

/usr/local/bin/mysqldump --skip-lock-tables --ignore-table=log.log --user="mysql-u1494" --password="my-password" names > dump.sql

When I run this command manually inside of the terminal it works fine. So the question is, why doesn't this query run?

Possible authentication problem, my first wild guess. Have you looked at the MySQL log(s) for other clues? — user2578094
– user2578094, Commented Jul 21, 2013 at 1:34

peterm · Accepted Answer · 2013-07-21 01:35:18Z

1

Probable causes are

because you didn't provide a full path for mysql
your password contains characters that need to be escaped

Try to change

mysql -u mysql-u1494 -pmy-password -D cache -e "DELETE FROM cache WHERE job IN('SET', 'UO', 'AV');"

to

/usr/local/bin/mysql -u mysql-u1494 -p"my-password" -D cache -e "DELETE FROM cache WHERE job IN('SET', 'UO', 'AV');"
^^^^^^^^^^^^^^                        ^           ^

answered Jul 21, 2013 at 1:35

peterm

93k16 gold badges157 silver badges162 bronze badges

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

1 Comment

Lucas Over a year ago

Argh. Yes - thats was the problem. Thank you Peter. Will accept the answer within 5 minutes.

Collectives™ on Stack Overflow

MySQL query doesn't run within cronjob

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related