linux定时备份（删除）mysql为压缩文件

/root/.my.cnf

[client]
user=root
password=abc123

mysqlbackup.sh

#!/bin/bash

date_str=$(date +"%Y%m%d-%H%M%S")
backup_dir="/home/deploy/sql/auto"
mkdir -p "$backup_dir"

# 直接导出并压缩
mysqldump Platform | gzip > "$backup_dir/platform_$date_str.sql.gz"

# 删除 30 天之前的压缩备份
find "$backup_dir" -name "platform_*.sql.gz" -type f -mtime +30 -exec rm -f {} \;