▍Скрипт бэкапа Mysql¶
# user & password
USER=root
PASS=password
# number of backups to be saved
KEEP=30
# dir to backup
DIR=/backup/mysql
NOW=$(date +"%Y-%m-%d")
FILE=$DIR/mysql_$NOW-$(date +"%T").sql.gz
BACKUPS=`find $DIR -name "mysql_*.gz" | wc -l | sed 's/\ //g'`
while [ $BACKUPS -ge $KEEP ]
do
ls -tr1 $DIR/mysql_*.gz | head -n 1 | xargs rm -f
BACKUPS=`expr $BACKUPS - 1`
done
mysqldump -u $USER -p$PASS --events --routines --triggers -A --opt | gzip -9 > $FILE
exit 0