Centos 自動備份mysql

1、建立備份檔案夾[plain]view plaincopy

1. cd/mnt/cp_disk/
2. mkdirbackup
3. cdbackup
4. mkdirdatabak
5. mkdirdb
6. mkdirlogs

2、編寫執行指令碼[plain]view plaincopy

1. #!/bin/bash
2. backup_dir=/mnt/cp_disk/backup/databak#備份臨時檔案存放目錄
3. backup_target_dir=/mnt/cp_disk/backup/db#備份檔案存放目錄
4. backup_logs_dir=/mnt/cp_disk/backup/logs#備份日誌目錄
5. db=gzcpc
6. DATE=$(date+%Y%m%d)
7. #得到10天前的日期
8. ccDATE=$(date"-d10dayago"+%Y%m%d)
9. echo"開始複製資料表">>$backup_logs_dir/$db$DATE
10. echo"-----------`date+"%Y-%m-%d%H:%M:%S"`--------------------">>$backup_logs_dir/$db$DATE
11. cp-R/var/lib/mysql/$db$backup_dir/#mysql資料庫的資料目錄為/var/lib/mysql/
12. echo"開始壓縮資料表">>$backup_logs_dir/$db$DATE
13. echo"------------------------">>$backup_logs_dir/$db$DATE
14. cd$backup_dir
15. tar-zcvf$db$DATE.tar.gz$db/&&echo"壓縮表結束">>$backup_logs_dir/$db$DATE
16. mv$db$DATE.tar.gz$backup_target_dir/&&echo"轉移成功">>$backup_logs_dir/$db$DATE
17. if[$?-eq0]
18. then
19. echo"backupsucceed">>$backup_logs_dir/$db$DATE
20. else
21. echo"backupfail">>$backup_logs_dir/$db$DATE
22. fi
23. echo"開始刪除原資料表">>$backup_logs_dir/$db$DATE
24. echo"-----------------------">>$backup_logs_dir/$db$DATE
25. rm-rf$backup_dir/*&&echo"刪除原資料表">>$backup_logs_dir/$db$DATE
26. echo"刪除10天前資料">>$backup_logs_dir/$db$DATE
27. if[-e$backup_target_dir/db$ccDATE.tar.gz]
28. then
29. rm-rf$backup_target_dir/db$ccDATE.tar.gz
30. echo"Delete$backup_target_dir/db$ccDATE.tar.gzsucceed">>$backup_logs_dir/$db$DATE
31. else
32. echo"Notfound$backup_target_dir/db$ccDATE.tar.gzfile">>$backup_logs_dir/$db$DATE
33. fi
34. if[-e$backup_logs_dir/$db$ccDATE]
35. then
36. rm-rf$backup_logs_dir/$db$ccDATE
37. echo"Delete$backup_logs_dir/$db$ccDATEsucceed">>$backup_logs_dir/$db$DATE
38. else
39. echo"Notfound$backup_logs_dir/$db$ccDATEfile">>$backup_logs_dir/$db$DATE
40. fi

3、賦予指令碼許可權[plain]view plaincopy

1. chmod755/home/backup_mysql.sh

4、建立定時任務[plain]view plaincopy

1. crontab–e
2. 10***/bin/bash/home/backup_mysql.sh