We use the following script (via a cron job) to get a distinct file for each database. We then only back up the /var/spool/mysqldumps directory. We run the script about an hour before the backups kick off.
LP #!/bin/bash # Daily database dumps for inclusion in amanda backups. MYU="/mysql user with appropriate permissions/" MYP="/mysql users password/" MYDBS=`mysql -e "show databases;" -u $MYU -p$MYP|sed -e 's/|//g' |sed -e '1d'` for d in $MYDBS; do mysqldump --user=$MYU --password=$MYP $d > /var/spool/mysqldumps/$d.sql done
