mysql数据库备份脚本
#!/bin/sh
############################################################
dump=/usr/bin/mysqldump
user=root
password=1qaz123
bak_url=/hstorage/mysqlbak
dataname=databasename
datanum=7
if [ ! -d "$bak_url" ]; then
mkdir -p "$bak_url"
fi
$dump -u$user -p$password --default-character-set=utf8 $dataname | gzip > $bak_url/${dataname}_$(date +%Y%m%d_%H%M%S).sql.gz
find $bak_url -name "*." -mtime +$datanum -type f | xargs rm -rf