linux定时自动备份mysql数据库

bashtouch /path/to/mysql_backup.sh
chmod +x /path/to/mysql_backup.sh

bashnano /path/to/mysql_backup.sh

bash#!/bin/bash

# 配置数据库连接信息
DB_USER="your_username"
DB_PASSWORD="your_password"
DB_NAME="your_database_name"

# 配置备份存储路径和文件名
BACKUP_DIR="/path/to/backup/directory"
DATE=$(date +%Y%m%d%H%M%S)
BACKUP_FILE="$BACKUP_DIR/$DB_NAME-$DATE.sql"

# 创建备份目录（如果不存在）
mkdir -p $BACKUP_DIR

# 使用mysqldump命令备份数据库
mysqldump -u$DB_USER -p$DB_PASSWORD $DB_NAME > $BACKUP_FILE

# 检查备份是否成功
if [ $? -eq 0 ]; then
  echo "Backup successfully: $BACKUP_FILE"
else
  echo "Backup failed!"
fi

bashcrontab -e

bash0 2 * * * /path/to/mysql_backup.sh