1

I have this cron:

00 0 * * * root /home/bitnami/backup.sh > /home/bitnami/backup.log

The Backup script contains:

#!/bin/bash

cd /tmp
file=$(date +%Y-%m-%d).sql
mysqldump \
  --host localhost \
  --port 3306 \
  -u user \
  --password="123" \
  bitnami > ${file}
if [ "${?}" -eq 0 ]; then
  gzip ${file}
  aws --region us-west-2 s3 cp ${file}.gz s3://backups/fc-wiki/
  rm ${file}.gz
else
  echo "Error backing up mysql"
  exit 255
fi

Which works fine when executing it by hand (sudo .\backup.sh)

When the crontab runs it only logs the following error in backup.log: Error backing up mysql

Is there a problem how I'm setting up the cron tab with the piping to log perhaps? Even without the piping it doesn't work.

Roger Far
  • 340

0 Answers0