mysql 全备脚本

xyaxlz

 

1. #!/bin/sh
2. 
   
3. BakDir=/data/dbbak/121.14.23.207/full
4. 
   
5. LogFile=/data/dbbak/121.14.23.207/full/db_backup.log
6. 
   
7. DATE=`date +'%Y%m%d_%H_%M'`
8. 
   
9. LOGDATE=`date +'#%Y-%m-%d %H:%M:%S'`
10. 
    
11. #DumpFile=dbbackup_$HOSTNAME_$DATE.sql
12. 
    
13. #GZDumpFile=dbbackup_$HOSTNAME_$DATE.sql.tar.gz
14. 
    
15. conffile=/data/dbbak/scripts/bak.ini
16. 
    
17. #DB define
18. 
    
19. DBUSER=$(awk -F "=" -v var=DBUSER '$1==var"" {print $2}' $conffile)
20. 
    
21. DBPWD=$(awk -F "=" -v var=DBPWD '$1==var"" {print $2}' $conffile)
22. 
    
23. MYSQLDIR=$(awk -F "=" -v var=MYSQLDIR '$1==var"" {print $2}' $conffile)
24. 
    
25. DBNAME=$(awk -F "=" -v var=DBNAME '$1==var"" {print $2}' $conffile)
26. 
    
27. #DumpFile=bak_$DBNAME_$DATE.sql
28. 
    
29. #ftp
30. 
    
31. ftpuser=$(awk -F "=" -v var=FTPUSER '$1==var"" {print $2}' $conffile)
32. 
    
33. ftppwd=$(awk -F "=" -v var=FTPPWD '$1==var"" {print $2}' $conffile)
34. 
    
35. ftpserver=$(awk -F "=" -v var=FTPSERVER '$1==var"" {print $2}' $conffile)
36. 
    
37. FTP_DIR=$(awk -F "=" -v var=FTPDIR '$1==var"" {print $2}' $conffile)
38. 
    
39. #ssh
40. 
    
41. sshuser=$(awk -F "=" -v var=SSHUSER '$1==var"" {print $2}' $conffile)
42. 
    
43. sship=$(awk -F "=" -v var=SSHIP '$1==var"" {print $2}' $conffile)
44. 
    
45. cd $BakDir
46. 
    
47. for i in $DBNAME
48. 
    
49. do
50. 
    
51. echo `date +'#%Y-%m-%d %H:%M:%S'` begin backup $i ....>>$LogFile
52. 
    
53. $MYSQLDIR/mysqldump -u$DBUSER -p$DBPWD --skip-opt --create-option --add-drop-table --single-transaction -E -e -q --set-charset --master-data=2 -
54. 
    
55. -hex-blob $i >bak_${i}_$DATE.sql
56. 
    
57. #$MYSQLDIR/mysqldump -u$DBUSER -p$DBPWD --skip-opt --add-drop-table --add-locks --create-options --disable-keys --quick --hex-blob $i>bak_${i
58. 
    
59. }_$DATE.sql
60. 
    
61. resultbak=$?
62. 
    
63. echo result: $resultbak>>$LogFile
64. 
    
65. if [ $resultbak -eq 0 ];then
66. 
    
67. echo `date +'#%Y-%m-%d %H:%M:%S'` end backup $i ....>>$LogFile
68. 
    
69. else
70. 
    
71. curl "http://219.239.93.43/submitalarmstate.php?game=dba_rdb&type=RDB&state=ALARM&description=bakfail"
72. 
    
73. exit;
74. 
    
75. fi
76. 
    
77. done
78. 
    
79. ######## gzip
80. 
    
81. for i in $DBNAME
82. 
    
83. do
84. 
    
85. echo `date +'#%Y-%m-%d %H:%M:%S'` begin tar $i ....>>$LogFile
86. 
    
87. gzip bak_${i}_$DATE.sql
88. 
    
89. resulttar=$?
90. 
    
91. echo tarresult:$resulttar>>$LogFile
92. 
    
93. if [ $resulttar -eq 0 ];then
94. 
    
95. echo `date +'#%Y-%m-%d %H:%M:%S'` end tar $i ....>>$LogFile
96. 
    
97. else
98. 
    
99. curl "http://219.239.93.43/submitalarmstate.php?game=dba_rdb&type=RDB&state=ALARM&description=tarfail"
100. 
     
101. exit;
102. 
     
103. fi
104. 
     
105. done
106. 
     
107. ############# ftp
108. 
     
109. for i in $DBNAME
110. 
     
111. do
112. 
     
113. md5sum bak_${i}_$DATE.sql.gz > bak_${i}_$DATE.sql.gz.md5
114. 
     
115. #
116. 
     
117. #curl -T bak_${i}_$DATE.sql.gz -u $ftpuser:$ftppwd $ftpserver/$FTP_DIR/
118. 
     
119. #curl -T bak_${i}_$DATE.sql.gz.md5 -u $ftpuser:$ftppwd $ftpserver/$FTP_DIR/
120. 
     
121. #
122. 
     
123. ##md5
124. 
     
125. #
126. 
     
127. #ssh $sshuser@$sship md5sum /mysqlbackup/database/$FTP_DIR/bak_${i}_$DATE.sql.gz > $BakDir/bak_${i}_$DATE.sql.gz_ftp.md5
128. 
     
129. #localmd5=$(cat $BakDir/bak_${i}_$DATE.sql.gz.md5 |awk '{print $1}')
130. 
     
131. #remotemd5=$(cat $BakDir/bak_${i}_$DATE.sql.gz_ftp.md5 |awk '{print $1}')
132. 
     
133. # if [ $localmd5 = $remotemd5 ] ;then
134. 
     
135. # echo `date +'%Y%m%d %H:%M:%S'` ftpsucess $?>>$LogFile
136. 
     
137. # else
138. 
     
139. # echo `date +'%Y%m%d %H:%M:%S'` ftpfail $?>>$LogFile
140. 
     
141. # curl "http://219.239.93.43/submitalarmstate.php?game=dba_rdb&type=RDB&state=ALARM&description=ftp_fail"
142. 
     
143. # fi
144. 
     
145. #
146. 
     
147. #
148. 
     
149. done
150. 
     
151. ##rm -f $DumpFile