mysql数据还原脚本

脚本

#!/bin/bash
# 设置备份文件夹路径
BACKUP_DIR="/data/db/sql"
echo "sql目录是: $BACKUP_DIR"

# 遍历并还原所有建表的 SQL 文件
for data_file in ${BACKUP_DIR}/*.sql; do
    echo "还原:$data_file"
    mysql -u root -p123456 -h 192.168.0.166 -P3307 smart_fish_online_20240821 < "$data_file"
    # 判断导入命令是否成功
    if [ $? -eq 0 ]; then
      rm -rf "$data_file"
      echo "已还原:$data_file"
    else
      echo "执行失败"
    fi
    echo "-"
done

用docker

docker run -v /data/db/:/data/db/ -it atomhub.openatom.cn/library/mysql:5 /bin/bash -c "cd /data/db/ && sh /data/db/restore.sh"