I have a crontask which runs at 1am every morning and dumps all databases.
0 1 * * * /var/backups/dumpit.sh 2>&1>> /var/backups/dumpit.log
The dumpit.sh
source:
#!/bin/bash
/usr/bin/mysqldump -u user -ppass --all-databases | gzip > /var/backups/mysql_`date +%u`.sql.gz
The script runs okay when executed manually but fails when run via the cron. Nothing is added to the dumpit.log
file. Do I need to turn on logging in my .myc.nf
file? Is there anything else I could try?