I have the below crontab configuration ;
45 9 * * * sh /home/renko/mysql.backup.sh > /home/renko/mysql_back_log.log
And my script is as below ;
#!/bin/bash
### Backup Folder dir ###
BAK="/var/www/backup/mysql/"
GZIP="$(which gzip)"
### FTP SERVER Login Stuff###
FTPU="someuser1"
FTPP="somepass1"
FTPS="someftpsite1"
FTPUU="someuser2"
FTPPP="somepass2"
FTPSS="someftpsite2"
NOW=$(date +"%d-%m-%Y")
[ ! -d $BAK ] && mkdir -p $BAK || /bin/rm -f $BAK/*
mysqldump -u root -h localhost --all-databases | gzip -9 > /var/www/backup/renko_backup_$NOW.sql.gz
lftp -u $FTPU,$FTPP -e "mput /var/www/backup/renko_backup_$NOW.sql.gz; quit" $FTPS > /home/renko/mysql_back_log.log
lftp -u $FTPUU,$FTPPP -e "cd some_dir;mput /var/www/backup/renko_backup_$NOW.sql.gz; quit" $FTPSS > /home/renko/mysql_back_log.log
mutt -s "database backup" [email protected] -a /var/www/backup/renko_backup_$NOW.sql.gz > /home/renko/mysql_back_log.log
mutt -s "Sunucu yedekleme" [email protected] -a /var/www/backup/renko_backup_$NOW.sql.gz > /home/renko/mysql_back_log.log
If I use the mysql.backup.sh command as below;
sudo sh /home/renko/mysql.backup.sh
the script works perfectly... However for some reason crontab doesn't make this script work. I can't find the log for crontab errors. Oh and before you ask I added the job in crontab via ;
sudo crontab -e
and restarted cron service via;
sudo service cron restart
I can't seem to find the problem. I am using Ubuntu Server with kernel 2.6.38-8. Any advice and pointing to any source would be welcomed.