#!/bin/bash
DATE=$(date +%Y%m%d_%H%M)
BACKUP_DIR=/var/www/WMS/backups
mkdir -p $BACKUP_DIR
mysqldump -u wms_user -pWms2024! wms_pro > $BACKUP_DIR/wms_pro_$DATE.sql
ls -t $BACKUP_DIR/wms_pro_*.sql | tail -n +31 | xargs rm -f 2>/dev/null
echo "$(date): Backup OK - wms_pro_$DATE.sql"