Automated SQL backup problem
Posted by: lacitpo
Posted on: 2009-02-26 12:21:00
I'm having issues with setting up an automated SQL backup.
I'm following the instructions from http://wiki.dreamhost.com/Automatic_Backup
My script is as follows with my private information removed
#!/bin/bash
cd /home/username/backup/
mkdir mysql
suffix=$(date +%y%m%d)
mysqldump --opt -uusername -ppassword -h sql.domain.com dbname > mysql/sitename_backup_.$suffix.sql
tar zcf archives/mysql_backup.$suffix.tar.gz mysql/*
mutt email@myemail.com -a /home/username/backup/archives/mysql_backup.$suffix.tar.gz -s "MySQL Backup"
rm -r mysql/
I get no errors. Checking behind the scenes, I found both the sql backup being grabbed, and it being successfully zipped. The freezup happens on the mutt command. I tried running it independently and it yielded the same results. Those results being a whole page of white nothingness in the command prompt and a complete stall.
I tried letting it run, thinking it may need time to complete, but it is a full stall.
Any help?