centos定时备份mysql数据库

sudo yum install mysql-devel -y

sudo nano /usr/local/bin/backup_mysql.sh

#!/bin/bash

# 数据库配置
DB_USER="your_mysql_username"
DB_PASS="your_mysql_password"
DB_NAME="your_database_name"
BACKUP_DIR="/path/to/backup/directory"

# 创建备份目录
mkdir -p $BACKUP_DIR

# 备份文件名
DATE=$(date +%Y%m%d%H%M%S)
BACKUP_FILE="$BACKUP_DIR/$DB_NAME-$DATE.sql"

# 执行备份
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_FILE

# 压缩备份文件
gzip $BACKUP_FILE

# 删除超过 7 天的备份文件
find $BACKUP_DIR -type f -name "*.sql.gz" -mtime +7 -exec rm {} \;

sudo chmod +x /usr/local/bin/backup_mysql.sh

sudo crontab -e

0 2 * * * /usr/local/bin/backup_mysql.sh

sudo yum install mysql-devel -y

sudo chown -R your_username:your_group /path/to/backup/directory
sudo chmod -R 755 /path/to/backup/directory

sudo systemctl status crond

sudo systemctl start crond
sudo systemctl enable crond