Percona Xtrabackup MySQL 全备
来源：互联网 发布：用友初始化数据库 编辑：程序博客网 时间：2024/05/29 06:53
#!/bin/shBACKUP_TIME=`date +%Y-%m-%d-%H-%M-%S`BACKUP_SOCK=/tmp/mysql3306.sockBACKUP_CNF=/etc/my3306.cnfBACKUP_USER=userBACKUP_PWD=123456BACKUP_DB=employeesBACKUP_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}
