25 lines
604 B
Bash
25 lines
604 B
Bash
#!/bin/bash
|
|
|
|
# 定义备份目录和文件名
|
|
backup_dir="/data/mysql_backup"
|
|
backup_file="$backup_dir/forgeplus-$(date +%Y%m%d%H%M%S).sql"
|
|
|
|
# MySQL 连接参数
|
|
mysql_host="172.20.32.202"
|
|
mysql_port="3306"
|
|
mysql_user="root"
|
|
mysql_password="gitlinK#%01"
|
|
database_name="forgeplus"
|
|
|
|
# 创建备份目录
|
|
mkdir -p "$backup_dir"
|
|
|
|
# 执行备份命令
|
|
mysqldump -h "$mysql_host" -P "$mysql_port" -u "$mysql_user" -p"$mysql_password" "$database_name" > "$backup_file"
|
|
|
|
# 检查备份结果
|
|
if [ $? -eq 0 ]; then
|
|
echo "MySQL backup successfully created: $backup_file"
|
|
else
|
|
echo "MySQL backup failed!"
|
|
fi |