Advertisement
Guest User

Untitled

a guest
Mar 8th, 2017
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. #!/bin/sh
  2. ###############################
  3. #此脚本用来全量备份
  4. #Shawn
  5. #每天做一次全量备份
  6. ###############################
  7. #设置用户名和密码
  8. v_user="Your UserName"
  9. v_password="Your Password"
  10.  
  11. #mysql安装全路径
  12. MysqlDir=/usr/local/bin
  13.  
  14. #备份数据库
  15. database="Your DatabaseName"
  16.  
  17. #设置备份路径,创建备份文件夹
  18. BackupDir=/data
  19. Full_Backup=$BackupDir/Full_backup
  20.  
  21. mkdir -p $Full_Backup/$(date +%Y%m%d)
  22.  
  23. #开始备份,记录备份开始时间
  24. echo '=========='$(date +"%Y-%m-%d %H:%M:%S")'=========='"备份开始">>$Full_Backup/full_buckup.log
  25.  
  26. mysqldump -u$v_user -p$v_password --single-transaction --flush-logs --databases $database>$Full_Backup/$(date +%Y%m%d)/full_backup.sql
  27.  
  28. #压缩备份文件
  29. gzip $Full_Backup/$(date +%Y%m%d)/full_backup.sql
  30.  
  31. echo '=========='$(date +"%Y-%m-%d %H:%M:%S")'=========='"备份完成">>$Full_Backup/full_buckup.log
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement