一、备份脚本
#!/usr/bin/bash
path_current=$(cd "$(dirname "$0")"; pwd)
name_current=$(basename "$0" .sh)
echo $path_current
echo $name_current
if [ ! -d $path_current/backup/ ];then
echo "create backup path: $path_current/backup"
mkdir -p $path_current/backup
fi
path_backup=$path_current/backup/
echo "backup path: ${path_backup}"
dball=(commams-bigdata commams-bos commams-coupon commams-device commams-face commams-goods commams-log commams-logistics commams-marketing commams-member commams-oa commams-oauth commams-order commams-partner commams-pay commams-payaccount commams-peripherals commams-sms commams-wallet commams-wms)
for db in ${dball[@]};do
if [ ! -f ${path_backup}/"$db".sql ];then
echo "backup next database:$db"
mysqldump --host xxxxx --port 196227 -u abc -p'yyy3' --set-gtid-purged=off --databases "$db" > ${path_backup}/"$db".sql
if [ $? -ne 0 ]; then
rm -f ${path_backup}/"$db".sql
echo "failed to backup the database."
exit 1
fi
fi
done
echo "success to backup database from production"
二、restore.sh恢复脚本
#!/usr/bin/bash
path_current=$(cd "$(dirname "$0")"; pwd)
name_current=$(basename "$0" .sh)
echo $path_current
echo $name_current
if [ ! -d $path_current/backup/ ];then
echo "should first backup database."
exit 1
fi
path_backup=$path_current/backup/
echo "backup path: ${path_backup}"
dball=(commams-bigdata commams-bos commams-coupon commams-device commams-face commams-goods commams-log commams-logistics commams-marketing commams-member commams-oa commams-oauth commams-order commams-partner commams-pay commams-payaccount commams-peripherals commams-sms commams-wallet commams-wms)
for db in ${dball[@]};do
if [ -f ${path_backup}/"$db".sql ];then
echo "restore database:$db"
mysql --host sxxxxx --port 3307 -uroot -p'123456' < ${path_backup}/"$db".sql && echo "$db is ok"
fi
done
echo "success to restore database from production"
