Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
#!/bin/bash # backup_mysql.sh DB_NAME="myapp_db" BACKUP_DIR="/var/backups/mysql" DATE=$(date +%Y-%m-%d_%H-%M) FILE="$BACKUP_DIR/${DB_NAME}_$DATE.sql.gz" KEEP_DAYS=7 mkdir -p "$BACKUP_DIR" mysqldump --single-transaction --routines "$DB_NAME" \ | gzip > "$FILE" # Remove backups older than KEEP_DAYS find "$BACKUP_DIR" -name "*.sql.gz" -mtime +$KEEP_DAYS -delete echo "Backup complete: $FILE" # Crontab entry (runs at 2 AM daily): # 0 2 * * * /usr/local/bin/backup_mysql.sh >> /var/log/mysql_backup.log 2>&1
Result
Open