主要更改前面三行即可
#!/bin/bash
# MySQL连接参数
DB_HOST="192.168."
DB_USER="root"
DB_PASSWORD="xmd-mysql"
riqi=`date +'%Y%m%d'`
time=`date +'%Y%m%d-%H%M%S'`
# 备份保存目录
BACKUP_DIR="/data/backup/"
# 获取所有非系统数据库列表
DATABASES=$(mysql -h $DB_HOST -u $DB_USER -p$DB_PASSWORD -e "SHOW DATABASES;" | grep -Ev "(Database|mysql|performance_schema|information_schema)")
# 创建备份保存目录
mkdir -p $BACKUP_DIR/$riqi/$time
# 循环备份每个数据库
for DATABASE in $DATABASES
do
# 执行备份
sudo mysqldump -h $DB_HOST -u $DB_USER -p$DB_PASSWORD $DATABASE > $BACKUP_DIR/$riqi/$time/$DATABASE.sql
# 检查备份是否成功
if [ $? -eq 0 ]; then
echo "备份 $DATABASE 成功:$BACKUP_FILE"
else
echo "备份 $DATABASE 失败"
fi
done
恢复脚本
mysql -h 192.168.147.160 -u root -p密码 库名 < /路径/库名.sql
mysql -h 192.168.111.111 -u root -p1 che < /data/backup/20230912/20230912-232036/che.sql