一. mysql 數據庫備份 sh 腳本

1. vim sqlback.sh

#!/bin/bashUSER="root"        #賬號
PASSWORD="123456"  #密碼
DATABASE="test"    #數據庫名
BACKUP_DIR="/home/dev/mysql"   #備份存的目錄
TIMESTAMP=$(date +"%F")        #帶時間命名BACKUP_FILE="$BACKUP_DIR/$DATABASE-$TIMESTAMP.sql" mysqldump -u $USER -p$PASSWORD $DATABASE > $BACKUP_FILEif [ $? -eq 0 ]; thenecho "Backup succeeded: $BACKUP_FILE"
elseecho "Backup failed"
fi

2. chmod +x sqlback.sh

3. ./sqlback.sh

4. 執行完后會在 /home/dev/mysql 目錄下生成備份文件

二. mysql 數據庫恢復流程

1. 如果數據庫沒有存在，要先創建數據庫

 mysql -u root -p -e "CREATE DATABASE test;"

2. vim sqlRestore.sh

#!/bin/bash# MySQL credentials
USER="root"             #賬號
PASSWORD="123456"       #密碼
DATABASE="test"         #數據庫名
BACKUP_FILE="/home/dev/mysql/test-2024-06-04.sql.sql"   #數據庫備份的目錄# Run mysql to restore
mysql -u $USER -p$PASSWORD $DATABASE < $BACKUP_FILE# Check if the command succeeded
if [ $? -eq 0 ]; thenecho "Restore succeeded: $DATABASE"
elseecho "Restore failed"
fi

2. chmod +x sqlRestore.sh

3. ./sqlRestore.sh

4. 恢復成功