周海笑-新区(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
改改 放到计划任务里就可以了