MariaDB社区

标题: mysql full backup scripts [打印本页]

作者: yinshi_2 时间: 2011-5-16 17:25
标题: mysql full backup scripts
file  fullbackuprept.sh

#!/bin/bash
#Using innobackupex-1.5.1 backup mysql rept databases

BACKUP_DATE=$(date +%Y%m%d)
BACKUP_DIR="/opt/ericsson/software/xtrabackup/report/${BACKUP_DATE}"
LOGFILE=${BACKUP_DIR}/run.log
BACKUP_SHDIR=/opt/ericsson/software/xtrabackup

if [ ! -d ${BACKUP_DIR} ]
then
mkdir -p ${BACKUP_DIR}
fi
${BACKUP_SHDIR}/fullbackupreptdetail.sh 2>>${LOGFILE}

file  fullbackupadmdetail.sh
#!/bin/bash
#Using innobackupex-1.5.1 backup mysql adn adm databases
# Mysql configuration file path
configuration_file=/opt/ericsson/3pp/mysql/mysql5145/my.cnf
#Backup Date
day=`date +%F`
#current day full backup schema file
#data_full_schemafile=$backup_path/schema_$day.tar.gz
BACKUP_DATE=$(date +%Y%m%d)
BACKUP_DIR="/opt/ericsson/software/xtrabackup/adm/${BACKUP_DATE}"
LOGFILE=${BACKUP_DIR}/run.log
BACKUP_TOOL=innobackupex-1.5.1
DBUSER=adm
DBPWD=adm
DBHOST=localhost
DBPORT=3306
SOCKET=/opt/ericsson/3pp/mysql/mysql5145/mysql.sock
data_full_datafile=${BACKUP_DIR}/backupadm_${BACKUP_DATE}.tar.gz
memory_capacity=256M
#LISTS="\" mysql adm \""
basefile=`basename ${configuration_file}`
oldconfig_file=${BACKUP_DIR}/${basefile}
#if [ ! -d ${BACKUP_DIR} ]
#then
#mkdir -p ${BACKUP_DIR}
#fi
echo "backup up start..."  ` date `  >  ${LOGFILE}
#full backup  database schema
if [ -f "${data_full_datafile}" ]; then
  rm ${data_full_datafile}&&rm ${oldconfig_file}&&echo "drop exist ${data_full_datafile} and ${oldconfig_file}" >> ${LOGFILE}
fi&&cp ${configuration_file} ${BACKUP_DIR}&&echo "cp ${configuration_file} to ${BACKUP_DIR}" >>${LOGFILE}&&${BACKUP_TOOL} --defaults-file=${configuration_file} --user=${DBUSER} --password=${DBPWD} --socket=${SOCKET}  --host=${DBHOST} --port=${DBPORT}  --stream=tar ${BACKUP_DIR} --slave-info --use-memory=${memory_capacity} --databases=" mysql adm "  --no-lock | gzip > $data_full_datafile 2>> ${LOGFILE}
if [ -f "${data_full_datafile}" ]
then
echo "backup successed,create ${data_full_datafile}" >> ${LOGFILE}
else
echo "backup unsuccessed. " >> ${LOGFILE}
fi&&echo " back up end ..." `date` >> ${LOGFILE}

欢迎光临 MariaDB社区 (http://123.56.88.72/)