Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- ###############################
- #此脚本用来全量备份
- #Shawn
- #每天做一次全量备份
- ###############################
- #设置用户名和密码
- v_user="Your UserName"
- v_password="Your Password"
- #mysql安装全路径
- MysqlDir=/usr/local/bin
- #备份数据库
- database="Your DatabaseName"
- #设置备份路径,创建备份文件夹
- BackupDir=/data
- Full_Backup=$BackupDir/Full_backup
- mkdir -p $Full_Backup/$(date +%Y%m%d)
- #开始备份,记录备份开始时间
- echo '=========='$(date +"%Y-%m-%d %H:%M:%S")'=========='"备份开始">>$Full_Backup/full_buckup.log
- mysqldump -u$v_user -p$v_password --single-transaction --flush-logs --databases $database>$Full_Backup/$(date +%Y%m%d)/full_backup.sql
- #压缩备份文件
- gzip $Full_Backup/$(date +%Y%m%d)/full_backup.sql
- echo '=========='$(date +"%Y-%m-%d %H:%M:%S")'=========='"备份完成">>$Full_Backup/full_buckup.log
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement