mysql异地备份批处理,MySQL备份脚本及异地备份

#!/bin/bash

#Mysql dabase information

#主机

find /aebiz/soft/databackup/* -type f -mtime +10  -name "*.gz" -exec rm {} \;

db_host="localhost"

#数据库帐号

db_user="root"

#数据库密码

db_passwd="123456"

#mysql安装目录

MYSQL="/aebiz/soft/mysql"

#mysql命令目录

MYSQLDUMP="/aebiz/soft/mysql/bin/mysqldump"

#Path information

#存放备份文件的路径

BACKUP_DB="/aebiz/soft/databackup"

LogFile=$BACKUP_DB"/bak.log"

#Time information

#时间

time=`date +"%Y-%m-%d-%H-%M-%S"`

day=`date +"%d"`

month=`date +"%Y-%m"`

weekday=`date +"%u"`

#Path enable write

if [ ! -w "$BACKUP_DB" ]; then

chmod -R 700 $BACKUP_DB

fi

#echo "**********************************host info****************************************"

#echo "db_host:"$db_host

#echo "db_user:"$db_user

#echo "db_passwd:"$db_passwd

#echo "MYSQL:"$MYSQL

#echo "MYSQLDUMP:"$MYSQLDUMP

#echo "databaseName:"$databaseName

#echo "BACKUP_DB:"$BACKUP_DB

#echo "**********************************************************************************"

#Mysql Backup

Date=`date +%Y%m%d`

Begin=`date +"%Y-%m-%d %H:%M:%S"`

#echo "start backup database:"$databaseName"  "$Begin

#databases

#需要备份的数据库，如果有多个数据库，请用,分隔

databaseList="ceshishop,ceshiydys,testshop0711,testydys0711"

for databaseName in `echo "$databaseList" | sed 's/,/\n/g'`

do

echo $databaseName

#fileName

#生成备份文件名

fileName=$databaseName"-"$time".sql"

#生成备份文件完整路径

BACKUP_DBPATH=$BACKUP_DB"/"$databaseName

#echo "***********************************database Info***********************************************"

#echo "BACKUP_DBPATH:"$BACKUP_DBPATH

#echo "fileName:"$fileName

#echo "**********************************************************************************"

if [ ! -d "$BACKUP_DBPATH" ]; then

mkdir "$BACKUP_DBPATH"

fi

#备份mysql

$MYSQLDUMP -u $db_user -p$db_passwd -h $db_host $databaseName > $BACKUP_DBPATH/$fileName

#打包.sql文件

cd $BACKUP_DBPATH && tar -czf $fileName.tar.gz $fileName && rm -rf $fileName && chmod go-rwx $fileName.tar.gz

Last=`date +"%Y-%m-%d %H:%M:%S"`

#echo "end backup database:"$databaseName"  "$Last

#输出日志

echo start:$Begin end:$Last $fileName succ >> $LogFile

done

scp -r  /aebiz/soft/databackup root@192.168.1.4:/aebiz/soft