简单的数据库备份脚本

#!/bin/bash
#00 03 * * * /bin/sh /export/scripts/db_backup.sh >/dev/null 2>&1
set -x
DB_SOURCE_HOST=127.0.0.1
DB_USER='root'
DB_PASSWORD='xxxxxxx'
BACKUP_ROOT=/export/dump/mysql
MYSQLDUMP="mysqldump -R --triggers -u$DB_USER -p$DB_PASSWORD "

$MYSQLDUMP -h $DB_SOURCE_HOST zhuangtu |gzip - > ${BACKUP_ROOT}/dump-WebUI01-zhuangtu-`date +%Y%m%d`.sql.gz
find $BACKUP_ROOT -type f -mtime +15 -delete