پاسخ : نگرفتن فول بکاب آپ
با این اسکریپت بکاپ بگیر ببین میشه
/bin/sh
NOW=$(date +"%d-%m-%Y")
DAY=$(date +"%a")
MUS="MYSQL_USERNAME"
MPA="MYSQL_BACKUP"
MHO="localhost"
MDB="DATABASE_NAME"
MYSQL="$(which mysql)"
GZIP="$(which gzip)"
LOG="/root/backup.log"
RIP="REMOTE_BACKUP_SERVER_IP"
RPATH="/home/daily/$(date +'%d-%m-%Y')"
EMAIL="mohsenshahbazi@gmail.com"
echo "Backup started in $(date +'%d-%m-%Y %H:%M:%S')" > $LOG
tables=$(mysql -ss -h $MHO -u $MUS -p$MPA $MDB -e'show tables;')
#tables=$(mysql -ss -h $MHO -u $MUS -p$MPA $MDB -e"show tables LIKE '%$1%';") uncomment to backup specific table in database
f="$(ssh root@$RIP mkdir -p $RPATH)"
for t in $tables
do
FILE=mysql-$MDB-$NOW-$(date +"%T")-$t.gz
echo "Dumping $t"
mysqldump -u $MUS -p$MPA $MDB --tables "$t" | $GZIP -9 > $FILE
echo "Table $t BACKED UP - $(date)" >> $LOG
scp ./$FILE root@$RIP:$RPATH
echo "$t Moved to backup server"
rm -fr $FILE
echo "$t BackupFile Has Been Deleted"
done
echo "Date :$(date)">>$LOG
echo "HOST:$(hostname)">>$LOG
echo "BACKUP DONE">>$LOG
mail -s "Daily backup-$(date +'%d-%m-%Y') Done" "$EMAIL" <$LOG
پاسخ با نقل قول
