#!/bin/bash
while getopts ":u:p:" OPT;do
case $OPT in
u)
user=$OPTARG
;;
p)
password=$OPTARG
;;
*)
echo "Usage: mysqlbackup -u username -p passowrd"
;;
esac
done
mysqldump=$(which mysqldump)
innobackupex=$(which innobackupex)
python=$(which python)
tar=$(which tar)
date=$(date +%y-%m-%d-%H-%M-%S)
pip=$(which pip)
host=$(hostname)
ossupload='/jf/scripts/backup/oss.py'
tardir='/jf/backup'
backupdir='/jf/backup/mysql'
tarname=${host}-${date}.tar.gz
timedir=$(date +%y-%m)
ossbackupdir=/mnt/ossfs/mysql/${timedir}/${host}
[ ! -d $backupdir ] && mkdir -p $backupdir
[ ! -d $ossbackupdir ] && mkdir -p $ossbackupdir
#全备
$innobackupex --user=$user --password=$password --slave-info --safe-slave-backup $backupdir
if [[ $? -ne 0 ]]
数据备份shell
于 2020-08-28 10:43:29 首次发布