script backup quotidien d'une base mysql

#!/bin/bash

# setup
suffix=`date +%Y%m%d`
cmd='/usr/bin/mysqldump'

echo "backup..."
${cmd} --user=root --single-transaction #db_name | bzip2 -c > db_${suffix}.sql.bz2

echo "ftp..."
# chmod 600 .netrc
ftp -n #ftp_server <<End-Of-Session
user #user #password
binary
put db_${suffix}.sql.bz2
bye
End-Of-Session

echo "backup done"