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