#!/bin/sh
filename=`date +%Y%m%d`
base_dir=/home/backip_databases/data
mysqldump edu_work>>$base_dir/database_$filename.sql
tar -zcvf $base_dir/database_$filename.tar.gz $base_dir/database_$filename.sql
rm -rf $base_dir/database_$filename.sql
find $base_dir -name "database_*" -type f -mtime +7 -exec rm {} \;

BlogPost5 min read
mysql定时备份脚本
Written on 2024.03.25