How to structure a cron job and script to execute sql command

Question

I have a MySQL database accessible through CPANEL. I want to execute a SQL command to DELETE from dbtable where eventdate = 'YYYY-MM-DD'. This is my cron job.

curl -L --max-redirs 1000 -v "https://ottawaoc.ca/test/files/delete_dates.sh" 1>/dev/null

and here is the shell script

#!/bin/bash
mysql --user = "ottawaoc_test" --password = "test ps" --database = "ottawaoc_test" --execute ="DELETE FROM `h8be5_eventregistration` WHERE `eventdate` = '2020-09-27'"

(I do insert the correct password.) I get output mailed to me and it seems to get the shell script but nothing happens within the database.

Could someone help to give me the correct commands and/or tell me how I can get errors from MySQL.

That's not how CGI works. Your CGI code needs to return proper headers. — jordanm
– jordanm, Commented Sep 8, 2020 at 21:15

fadil eldin · Accepted Answer · 2020-09-08 22:42:07Z

1

I used to run mysql crons by putting this in the shell:

#!/bin/bash
echo "mysql statement;" | mysql -B -hHOST -uUSER -pPASS DBNAME

answered Sep 8, 2020 at 22:42

fadil eldin

1561 silver badge8 bronze badges

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

Collectives™ on Stack Overflow

How to structure a cron job and script to execute sql command

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