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 |
#!/bin/bash # Shell script ile MySQL veritabani tablo tablo (innodb) yedekleme # omer oner source /etc/profile DEST="/data/backup/mysql" DATE=`date +%Y-%m-%d` MYSQL="$(which mysql)" MYSQLDUMP="$(which mysqldump)" ZIP="$(which gzip)" FIND="$(which find)" DBS="$($MYSQL -Bse 'show databases')" LOG="/data/backup/mysql/dump.log" mkdir $DEST/$DATE echo "Start:$(date +%Y-%m-%d/%T)" >> $LOG for db in $DBS do mkdir $DEST/$DATE/$db TABLES=`echo "show tables"| $MYSQL $db -N>/tmp/tables` while read i do $MYSQLDUMP --routines --single-transaction $db $i > $DEST/$DATE/$db/$i.sql $ZIP -f $DEST/$DATE/$db/* # dosyaları zipliyoruz. done < /tmp/tables done $FIND $DEST -maxdepth 1 -type d -mtime +2 -exec rm -rf {} \; echo "Finish:$(date +%Y-%m-%d/%T)" >> $LOG echo " " >> $LOG |