#!/bin/bash  

# MySQL备份脚本  

export PATH=/usr/local/bin/:$PATH
# MySQL连接信息  
DB_HOST="localhost"
DB_USER="root"
DB_PASS="test1644"
DB_NAME="xxpay"

dd=$(date +\%Y\%m\%d\%H\%M\%S)
# 备份文件存储路径  
BACKUP_DIR="/package/xxpay/backup/mysql"
#BACKUP_FILE="${BACKUP_DIR}/xxpay_backup_$(date +\%Y\%m\%d\%H\%M\%S).sql"  
BACKUP_FILE="${BACKUP_DIR}/xxpay_backup_$dd.sql"

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

# 使用mysqldump进行数据库备份  
#cd /usr/local/mysql/bin/
/usr/local/mysql/bin/mysqldump -h $DB_HOST -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_FILE

# 检查备份是否成功  
if [ $? -eq 0 ]; then
    echo "数据库备份成功！备份文件：$BACKUP_FILE"  
else
    echo "数据库备份失败！"  
fi


#2. 写入liunx定时任务
crontab -e 0 2 * * * /**.sh