#!/bin/bash

bases_datos=(efai acervos exhibicion_espacios exhibicion_programas focine_animacion focine_cortometraje focine_documental focine_estados focine_experimental focine_ficcion focine_infancias focine_operasprimas focine_postproduccion)

IP_SERVER="192.168.247.200"

USUARIO="micrositio_user"

CLAVE="m1cr0s1t10"

DATE=$(date +"%d_%m_%Y")

DATE_FULL=$(date +"%d_%m_%Y")

BACKUP_DIR="/var/www/backup_bd_focine/$DATE"

BACKUP_DELETE="/var/www/backup_bd_focine/*"
find $BACKUP_DELETE/* -mtime +4 -type f -exec rm {} \;
find $BACKUP_DELETE -type d -empty -exec rmdir {} \;

mkdir -p $BACKUP_DIR



	for DB_NAME in ${bases_datos[@]}
	do
			BACKUP_FILE="$BACKUP_DIR/$DB_NAME.sql"

			# Comando mysqldump para realizar el respaldo

			mysqldump -h $IP_SERVER -u$USUARIO -p$CLAVE $DB_NAME > "$BACKUP_DIR/$DB_NAME.sql"
			
			# Verificar el éxito del comando mysqldump
			if [ $? -eq 0 ]; then
				echo "Respaldo completado con éxito: $BACKUP_FILE"
			else
				echo "Ocurrio un error al generar el respaldo $BACKUP_FILE"
			fi
	done