|
1234567891011121314151617181920212223242526272829303132333435363738394041424344 |
- #!/bin/bash
-
- export PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
- BAK_DIR=/var/backups/mysql
- LOG_DIR=/var/log/mysql
-
- echo "Starting Backup" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
- echo "---------" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
-
- xtrabackup --backup --target-dir=$BAK_DIR >> \
- $LOG_DIR/mysql-bak-$(date +%F).log 2>&1 || \
- echo "Backup failed with exit value $?" >> \
- $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
-
- echo "Backup Finished" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
- echo "---------" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
- echo "" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
-
- echo "Starting Prepare #1" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
- echo "---------" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
-
- xtrabackup --prepare --target-dir=$BAK_DIR >> \
- $LOG_DIR/mysql-bak-$(date +%F).log 2>&1 || \
- echo "Prepare #1 failed with exit value $?" >> \
- $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
-
- echo "Prepare #1 Finished" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
- echo "---------" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
- echo "" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
-
- echo "Starting Prepare #2" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
- echo "---------" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
-
- xtrabackup --prepare --target-dir=$BAK_DIR >> \
- $LOG_DIR/mysql-bak-$(date +%F).log 2>&1 || \
- echo "Prepare #1 failed with exit value $?" >> \
- $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
-
- echo "Prepare #2 Finished" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
- echo "---------" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
- echo "" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1
-
- # Delete logs older than 30 days
- find $LOG_DIR -name "mysql-bak-*" -mtime +30 -delete
|