#!/bin/bash
INNOBACKUPEX=/usr/bin/innobackupex
USER=root
PASS="XXXX"
SOCK=/webdata/opt/local/mysql33060/misc/mysql.sock
CONFIG_FILE=/webdata/opt/local/mysql33060/my.cnf
DATA_...
#!/bin/bash
INNOBACKUPEX=/usr/bin/innobackupex
USER=root
PASS="XXXX"
SOCK=/webdata/opt/local/mysql33060/misc/mysql.sock
CONFIG_FILE=/webdata/opt/local/mysql33060/my.cnf
DATA_DIR=/webdata/opt/local/mysql33060/data
FILE_BAK_DST_DIR=/webdata/huiyiding_db_bak
FILE_BAK_DST_HOST="10.24.35.43"
FILE_BAK_DST_PORT=16868
TIME_STAMP=`date +%Y%m%d%H`
TMP_DIR=/webdata/backup
cd $TMP_DIR
yum install -y pigz
$INNOBACKUPEX --user=$USER --password=$PASS --socket=$SOCK --defaults-file=$CONFIG_FILE --datadir=$DATA_DIR --stream=tar ./ | pigz|ssh -p $FILE_BAK_DST_PORT $FILE_BAK_DST_HOST "cat - >$FILE_BAK_DST_DIR/HYD_DB'_'$TIME_STAMP.tar.gz"
rm -rf $TMP_DIR/*
