shell脚本mysql

# 确保当前用户有权限执行MySQL命令
sudo chown -R your_user:your_group /path/to/mysql/data

# 修改MySQL配置文件my.cnf，增加或修改以下配置
[mysqld]
wait_timeout = 3600
interactive_timeout = 3600

# 检查Shell脚本中的MySQL命令语法
mysql -u username -p -e "SELECT * FROM table_name;"

#!/bin/bash

# 数据库配置
DB_USER="your_username"
DB_PASS="your_password"
DB_NAME="your_database"
BACKUP_DIR="/path/to/backup"

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

# 备份数据库
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_DIR/backup_$(date +%Y%m%d%H%M%S).sql

# 压缩备份文件
gzip $BACKUP_DIR/backup_$(date +%Y%m%d%H%M%S).sql

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