#!/bin/bash

设置备份文件的存储路径

backup_dir="/backup/mysql"

获取当前时间

time=$(date +"%Y-%m-%d_%H-%M-%S")

创建备份文件夹

mkdir -p $backup_dir/$time

备份数据库

mysqldump -h localhost -u root -p password --all-databases > $backup_dir/$time/all-databases.sql

压缩备份文件

tar -czvf $backup_dir/$time.tar.gz $backup_dir/$time

删除原始备份文件夹

rm -rf $backup_dir/$time

删除过期备份文件

find $backup_dir -type f -name "*.tar.gz" -mtime +30 -exec rm {} ;

输出备份完成信息

echo "Backup completed at $time."