bash执行mysql

#!/bin/bash

# 数据库配置
DB_USER="your_username"
DB_PASS="your_password"
DB_NAME="your_database_name"
BACKUP_DIR="/path/to/backup/directory"
DATE=$(date +%Y%m%d%H%M%S)

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

# 执行备份
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_DIR/backup_$DATE.sql

# 压缩备份文件
gzip $BACKUP_DIR/backup_$DATE.sql

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

sudo -u mysql_user mysqldump -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_DIR/backup_$DATE.sql

sudo apt-get install mysql-client  # Debian/Ubuntu
sudo yum install mysql            # CentOS/RHEL

mysqldump -h localhost -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_DIR/backup_$DATE.sql