Thanks for the hint, I can’t get it right though.
Using my ftp I made backups and archive directories.
In the backups directory I put in mysql.sh which is…which I chmod to 755 along with the backup directory
mysqldump --opt -uUser -ppass -h mysqlA.domain.com db_nameA > mysql/db_nameA.$suffix.sql
mysqldump --opt -uUser -ppass -h mysqlB.domain.com db_nameB > mysql/db_nameB.$suffix.sql
tar zcf archives/mysql_backup.$suffix.tar.gz mysql/*
mutt email@example.com -a /home/username/backups/archives/mysql_backup.$suffix.tar -s "MySQL Backup"
rm -r mysql/
Then I created a shell account and setup a cronjob which commands simply
now I’m guessing my cronjob is bad but I was also noticing there is no space between the -u and p and the password, is that right?
Thanks for the help - Justin