#!/bin/bash

# MySQL database credentials
DB_USER="rdempleo_rpplaza"
DB_PASS='MysuperMechy'
DB_NAME="rdempleo_rpplaza"

# Backup directory
BACKUP_DIR="/home1/rdempleo/rpplaza.com/database-daily-backups"

# Date (YYYYMMDD format)
DATE=$(date +%Y%m%d)

# Backup file name
BACKUP_FILE="$BACKUP_DIR/$DB_NAME-$DATE.sql"

# MySQL dump command
mysqldump -u$DB_USER -p$DB_PASS --no-tablespaces $DB_NAME > $BACKUP_FILE