网友周海笑的crontab 有大用

周海笑-新区(105187501)  17:17:06
给你一个shell
#!/bin/bash
# This script run at 00:00
bak_path="/data/back/db/"
mkdir -p ${bak_path}$(date -d "yesterday" +"%Y")/$(date -d "yesterday" +"%m")/

/opt/server/mysql/bin/mysqldump --all-databases -h127.0.0.1 -uroot -pyourpasswd | gzip >${bak_path}dbbak.gz

mv ${bak_path}dbbak.gz ${bak_path}$(date -d "yesterday" +"%Y")/$(date -d "yesterday" +"%m")/dbbak_$(date -d "yesterday" +"%Y%m%d").gz

改改 放到计划任务里就可以了