MySQL全备和增备

#!/bin/bash

MYSQL_BACKUP=date +%Y%m%d
MYSQL_LOG_BIN=ls /var/lib/mysql/mysql-bin.[0-9]* | head -n 1 | sort -rg | head -n 1
num=$1if[!-d/opt/$MYSQL_BACKUP ];then
mkdir /opt/$MYSQL_BACKUP -p
fi

#全备
mysql_all(){
mysqldump -uroot --flush-logs --master-data --all-databases > /opt/$MYSQ{L}_{B}ACKUP/${MYSQL_BACKUP}.sql
}

#增备
mysql_increment(){
mysqldump -uroot --flush-logs
cp $MYSQ{L}_{L}O{G}_{B}IN/opt/$MYSQL_BACKUP
}

case $num in
1)
mysql_all
;;
2)
mysql_increment
;;
*)
exit
esac