Mysql 运维相关脚本收集

mysql 版本： 5.6

Mysql 分库备份脚本

#!/bin/sh#Backup databases into separated files excluding system schemasBACKUP_FOLDER=/home/okchem/mysqlbackupMYUSER=userMYPASS=passwordSOCKET=/data/mysql/mysql.sockMYCMD="mysql -u$MYUSER -p$MYPASS -S $SOCKET"MYDUMP="mysqldump -u$MYUSER -p$MYPASS -S $SOCKET"mkdir -p ${BACKUP_FOLDER}#for database in `$MYDUMP -e "show databases;"|sed '1,2d'|egrep -v "mysql|schema"`for database in `$MYCMD -e "show databases;" | egrep -Evi "database|mysql|schema|test"`do     $MYDUMP $database >${BACKUP_FOLDER}/${database}_$(date +%Y%m%d).sql    #If compression is needed, use this command: $MYDUMP $database |gzip >/server/backup/${database}_$(date +$F).sql.gzdone