mysqldump

#!/bin/bash
# 设置mysql的登录用户名和密码
mysql_user="root"
mysql_password="weye@2419"
mysql_host="localhost"
mysql_port="3306"
mysql_charset="utf8mb4"

# 备份文件存放地址
backup_location=/data/db-back

# 是否删除过期数据
expire_backup_delete="ON"
expire_days=7
backup_time=`date +%Y%m%d%H%M`
backup_dir=$backup_location
#welcome_msg="Welcome to use MySQL backup tools!"

# 备份指定数据库中数
mysqldump -uroot -pweye@2419 --single-transaction --all-databases |gzip > /data/db-back/"$backup_time".sql.gz

# 删除过期数据
if [ "$expire_backup_delete" == "ON" -a "$backup_location" != "" ];
then
`find $backup_location/ -mtime +$expire_days -name *.gz | xargs rm -rf`
fi