1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
| -
!
-
|
|
!
-
!
-
!
-
!
-
!
-
!
-
!
-
!
-
!
-
!
-
!
-
!
-
!
-
!
|
MAIL_ADDRESS="[email protected]"
MAIL_TITLE="[$(hostname)] DB バックアップ レポート"
DB_BACKUP_PATH="/home/bar/backup/db"
BACKUP_USER=bar
MAIL=/usr/bin/mail
LINE="--------------------"
DATE_FORMAT="%m/%d-%H:%M:%S"
OUTFILE=`/bin/mktemp` || exit 1
/bin/echo -e "\n$LINE " `date +$DATE_FORMAT` " Start DB Backup $LINE" >> $OUTFILE
/bin/mkdir -p $DB_BACKUP_PATH 2>> $OUTFILE
/bin/chown $BACKUP_USER:$BACKUP_USER $DB_BACKUP_PATH 2>> $OUTFILE
currentBackupPath=$DB_BACKUP_PATH/current.gz
/bin/rm $currentBackupPath 2> /dev/null
/usr/bin/mysqldump --user=<ユーザー名> --password=<パスワード> --events -x --all-databases | gzip > $currentBackupPath 2>> $OUTFILE
/bin/chown $BACKUP_USER:$BACKUP_USER $currentBackupPath 2>> $OUTFILE
/bin/echo -e "\n$LINE " `date +$DATE_FORMAT` " End DB Backup $LINE" >> $OUTFILE
/bin/cat $OUTFILE | tr -d '\r' | $MAIL -s "$MAIL_TITLE" "$MAIL_ADDRESS"
/bin/rm -f $OUTFILE
|