24 lines
670 B
Bash
24 lines
670 B
Bash
#!/bin/bash
|
|
|
|
# 定义备份文件路径和数据库信息
|
|
backup_file="/data/mysql_backup/forgeplus-{年月日}.sql"
|
|
mysql_host="172.20.32.202"
|
|
mysql_port="3306"
|
|
mysql_user="root"
|
|
mysql_password="gitlinK#%01"
|
|
database_name="forgeplus"
|
|
|
|
# 检查备份文件是否存在
|
|
if [ -f "$backup_file" ]; then
|
|
# 恢复数据库
|
|
mysql -h "$mysql_host" -P "$mysql_port" -u "$mysql_user" -p"$mysql_password" "$database_name" < "$backup_file"
|
|
|
|
# 检查恢复结果
|
|
if [ $? -eq 0 ]; then
|
|
echo "MySQL database successfully restored from backup."
|
|
else
|
|
echo "MySQL database restore failed!"
|
|
fi
|
|
else
|
|
echo "Backup file not found: $backup_file"
|
|
fi |