#!/bin/bash

设置备份文件的存储路径

bbackup_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.'