When logged on as root, I can run the following script to backup my MySQL databases to a local folder:
#!/bin/bash
BACKUPLOCATION=/var/local/mysqlbackups
LOGFILE=/usr/local/sbin/backupdbs.log
GZIP="$(which gzip)"
NOW=$(date +"%d-%m-%Y")
RETENTION=30
#remove .gz files greater than 30 days old
find /var/local/mysqlbackups -mtime +$RETENTION -exec rm -fr {} ; &> /dev/null
# back up all the mysql databases, into individual files so we can later restore
# them separately if needed.
mysql --defaults-extra-file=/root/.my.cnf -B -N -e "show databases" | while read db
do
BACKUPFILE=$BACKUPLOCATION/mysql-${db}.${NOW}-$(date +"%T").gz
echo "Backing up $db into $BACKUPFILE"
/usr/bin/mysqldump --defaults-extra-file=/root/.my.cnf --single-transaction $db | $GZIP -9 > $BACKUPFILE
done >>$LOGFILE
However, when I run the backup from bacula, I get the following error message...
The backup job is now running. When complete, the results will be shown below .. 05-Apr 16:18 cablemon-dir JobId 27: shell command: run BeforeJob "/usr/local/sbin/backupdbs"
05-Apr 16:18 cablemon-dir JobId 27: BeforeJob: Could not open required defaults file: /root/.my.cnf
05-Apr 16:18 cablemon-dir JobId 27: BeforeJob: Fatal error in defaults handling. Program aborted
05-Apr 16:18 cablemon-dir JobId 27: BeforeJob: ERROR 1045 (28000): Access denied for user 'bacula' < at > 'localhost' (using password: NO)
05-Apr 16:18 cablemon-dir JobId 27: Start Backup JobId 27, Job=BackupClient1.2012-04-05_16.18.54_33
05-Apr 16:18 cablemon-dir JobId 27: Using Device "FileStorage"
05-Apr 16:18 cablemon-sd JobId 27: Volume "Inc-0002" previously written, moving to end of data.
05-Apr 16:18 cablemon-sd JobId 27: Ready to append to end of Volume "Inc-0002" size=67985900
05-Apr 16:18 cablemon-fd JobId 27: Could not stat "/usr/sbin/local": ERR=No such file or directory
05-Apr 16:18 cablemon-sd JobId 27: Job write elapsed time = 00:00:01, Transfer rate = 0 Bytes/second
05-Apr 16:18 cablemon-dir JobId 27: Bacula cablemon-dir 5.0.1 (24Feb10): 05-Apr-2012 16:18:57The backup finishes ok, just not the script component. I first gave read access to /root/.my.cnf for the account "bacula", but I still got the error. I even set the permissions as 777 for .my.cnf and still I got the above error. I am using the .my.cnf file to hide the mysql username and password.
