1. vim sqlback.sh
#!/bin/bash
USER="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_FILE
if [ $? -eq 0 ]; then
echo "Backup succeeded: $BACKUP_FILE"
else
echo "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
USER="root"
PASSWORD="123456"
DATABASE="test"
BACKUP_FILE="/home/dev/mysql/test-2024-06-04.sql.sql"
mysql -u $USER -p$PASSWORD $DATABASE < $BACKUP_FILE
if [ $? -eq 0 ]; then
echo "Restore succeeded: $DATABASE"
else
echo "Restore failed"
fi
2. chmod +x sqlRestore.sh
3. ./sqlRestore.sh
4. 恢复成功