| Server IP : 173.209.174.21 / Your IP : 216.73.216.89 Web Server : Apache/2.4.58 (Ubuntu) System : Linux wcfs-server 6.8.0-124-generic #124-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 13:00:45 UTC 2026 x86_64 User : nodor ( 1000) PHP Version : 8.3.6 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /usr/local/bin/ |
Upload File : |
#!/bin/bash
set -e # Stop on error
# --- CONFIGURATION ---
DB_NAME="farm_accounts"
DB_USER="nodor"
DB_PASS="D@n33Nao40"
EMAIL_TO="nodor@nykoinc.com"
BACKUP_DIR="/var/www/wcfs/tabs/db_backups"
DATE=$(date +%Y%m%d_%H%M%S)
BACKUP_FILE="$BACKUP_DIR/db_backup_${DB_NAME}_$DATE.sql.gz"
# --- Ensure backup directory exists ---
mkdir -p "$BACKUP_DIR"
# --- BACKUP ---
mysqldump -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" | gzip > "$BACKUP_FILE"
# --- Verify backup file exists ---
if [ -f "$BACKUP_FILE" ]; then
# echo "Attached is the latest backup for database: $DB_NAME" | \
# /usr/bin/mailx -s "Database Backup for $DB_NAME ($DATE)" \
# -a "$BACKUP_FILE" \
# -r "info@wilsoncreekfarmsupply.com" \
# "$EMAIL_TO"
echo "Attached is the latest backup for database: $DB_NAME" | \
mutt -s "Database Backup for $DB_NAME ($DATE)" \
-a "$BACKUP_FILE" -- "$EMAIL_TO"
# --- CLEANUP ---
rm "$BACKUP_FILE"
else
echo "Backup failed: $BACKUP_FILE was not created."
fi