hanvari/cpanel-cronjob.md

Last active February 12, 2021 07:02

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/hanvari/58d151d38cce25a4a1ded337dd5a1cd0.js"></script>
Save hanvari/58d151d38cce25a4a1ded337dd5a1cd0 to your computer and use it in GitHub Desktop.

Download ZIP

Creating Cronjob in cPanel

Raw

cpanel-cronjob.md

Cron-Job creation in cPanel

Command for Automated MySQL DB Backup

mysqldump --triggers --routines --events --tz-utc \
          -u<user> -p<pass> <db-name> | \ 
          gzip -9 > /full/path/to/backup/folder/`date +"\%Y-\%m-\%d-\%H\%M"`_my_db.sql.gz

The date format parameters must be escaped as %
If the command results in any output to STDOUT, an email will be sent with that response. Otherwise there is no email.

Command for Running a PHP Script

/usr/local/bin/php -f /home/username/public_html/folder/file.php > /dev/null