Percona Xtrabackup MySQL 全备

最新推荐文章于 2024-06-01 15:29:46 发布

ylqmf

最新推荐文章于 2024-06-01 15:29:46 发布

阅读量1.3w

点赞数 1

分类专栏： MySQL

本文链接：https://blog.csdn.net/ylqmf/article/details/8713321

版权

MySQL 专栏收录该内容

70 篇文章 0 订阅

订阅专栏

#!/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}