Created
June 30, 2013 19:14
-
-
Save horsley/5896461 to your computer and use it in GitHub Desktop.
mysql分库备份脚本
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
#以下信息请自行修改 | |
MYSQL_DIR=/usr/local/mysql #mysql目录 | |
MYSQL_USER=root #mysql用户名 | |
MYSQL_PASS=123456 #mysql密码 | |
BACKUP_DIR=/backup #存放备份文件的目录 | |
#以上信息自行修改 | |
#定义数据库的名字和旧数据库的名字 | |
DataBakName=Data_$(date +”%Y%m%d”).tar.gz | |
OldData=Data_$(date -d -5day +”%Y%m%d”).tar.gz | |
#删除本地3天前的数据 | |
rm -rf $BACKUP_DIR/Data_$(date -d -3day +”%Y%m%d”).tar.gz | |
cd $BACKUP_DIR | |
#导出数据库,一个数据库一个压缩文件 | |
for db in `$MYSQL_DIR/bin/mysql -u$MYSQL_USER -p$MYSQL_PASS -e "SHOW DATABASES" |sed '1d'` | |
do | |
($MYSQL_DIR/bin/mysqldump -u$MYSQL_USER -p$MYSQL_PASS ${db} | gzip -9 > ${db}.sql.gz) | |
done | |
~ | |
~ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment