定时备份mysql指定数据库脚本,保留60天
#!/bin/bash # path cd /opt/pmo/mysql_data target_directory="/opt/pmo/mysql_data" # get time now current_time=$(date +%s) # cal 2 2months ago before_time=$(date -d "60 days ago" +%s) file_name=metersphere_`date +"%Y%m%d%H%M%S"` echo $file_name # delete find "$target_directory" -type f -name "*.sql" -ctime +$(( (current_time - before_time) / 86400 )) -exec rm {} \; find "$target_directory" -type f -name "*.tar.gz" -ctime +$(( (current_time - before_time) / 86400 )) -exec rm {} \; mysqldump -h 192.168.9.27 -ums_backup -pPassword123@mysql -P3307 backup_db> "$file_name".sql tar czf "$file_name".tar.gz "$file_name".sql rm -rf "$file_name".sql
标签:name,tar,sql,备份,mysql,file,time,定时 From: https://www.cnblogs.com/testway/p/17754266.html