Percona Xtrabackup MySQL全備

Percona Xtrabackup MySQL全備   [plain]  #!/bin/sh      BACKUP_TIME=`date +%Y-%m-%d-%H-%M-%S`   BACKUP_SOCK=/tmp/mysql3306.sock   BACKUP_CNF=/etc/my3306.cnf   BACKUP_USER=user   BACKUP_PWD=123456   BACKUP_DB=employees   BACKUP_DIR=/data/backup/mysql/backup3306/      BAK=${BACKUP_DIR}${BACKUP_DB}_${BACKUP_TIME}   INNOBACKUPEX=/opt/soft/xtrabackup-1.6.6/innobackupex      ${INNOBACKUPEX} --defaults-file=${BACKUP_CNF} --socket=${BACKUP_SOCK} --user=${BACKUP_USER} --password=${BACKUP_PWD} ${BAK} --no-timestamp   #${INNOBACKUPEX} --defaults-file=${BACKUP_CNF} --socket=${BACKUP_SOCK} --user=${BACKUP_USER} --password=${BACKUP_PWD} ${BAK} --no-timestamp --stream=tar > ${BAK}.tar   #${INNOBACKUPEX} --defaults-file=${BACKUP_CNF} --apply-log --use-memory=4G ${BAK}      cd ${BACKUP_DIR}   tar zcf ${BACKUP_DB}_${BACKUP_TIME}.tar.gz ${BACKUP_DB}_${BACKUP_TIME}   rm -rf ${BACKUP_DB}_${BACKUP_TIME}