Linux 备份mysql脚本（版本号）

 #!/bin/bash

    
  
    
 # MySQL配置
    
 DB_USER="your_mysql_username"
    
 DB_PASS="your_mysql_password"
    
 DB_NAME="your_database_name"
    
 DB_HOST="localhost"
    
  
    
 # 备份目录
    
 BACKUP_DIR="/path/to/your/backup/directory"
    
  
    
 # 当前日期
    
 DATE=$(date +%Y%m%d%H%M%S)
    
  
    
 # 备份文件名
    
 BACKUP_FILE="$BACKUP_DIR/backup_$DATE.sql"
    
  
    
 # 使用mysqldump命令备份数据库
    
 mysqldump -h $DB_HOST -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_FILE
    
  
    
 # 检查备份是否成功
    
 if [ $? -eq 0 ]; then
    
     echo "MySQL backup co