#!/bin/bash

# Configuración de la base de datos
DB_USER="mdasalf_respaldo"
DB_PASS="Mdai2023$%"
DB_NAME="mdasalf_form"
DB_NAME1="mdasalf_salf2"
DB_NAME2="mdasalf_salf3"
DB_NAME3="mdasalf_sf"
DB_NAME4="mdasalf_ss"

# Ruta donde se almacenarán los respaldos
BACKUP_DIR="/home/mdasalf/resp_bbdd"

# Obtener la fecha actual para el nombre del archivo de respaldo
BACKUP_DATE=$(date +"%d_%m_%Y_%H_%M_%S")
BACKUP_FILE="$BACKUP_DIR/$DB_NAME/backupMdasalf_form-$BACKUP_DATE.sql"
BACKUP_FILE1="$BACKUP_DIR/$DB_NAME1/backupMdasalf_salf2-$BACKUP_DATE.sql"
BACKUP_FILE2="$BACKUP_DIR/$DB_NAME2/backupMdasalf_salf3-$BACKUP_DATE.sql"
BACKUP_FILE3="$BACKUP_DIR/$DB_NAME3/backupMdasalf_sf-$BACKUP_DATE.sql"
BACKUP_FILE4="$BACKUP_DIR/$DB_NAME4/backupMdasalf_ss-$BACKUP_DATE.sql"

# Verificar si los directorios de respaldo existen o crearlos si no
mkdir -p "$BACKUP_DIR/$DB_NAME"
mkdir -p "$BACKUP_DIR/$DB_NAME1"
mkdir -p "$BACKUP_DIR/$DB_NAME2"
mkdir -p "$BACKUP_DIR/$DB_NAME3"
mkdir -p "$BACKUP_DIR/$DB_NAME4"

# Comando para realizar el respaldo
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_FILE
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME1 > $BACKUP_FILE1
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME2 > $BACKUP_FILE2
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME3 > $BACKUP_FILE3
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME4 > $BACKUP_FILE4