#!/bin/bash
DEPLOYMENT="phpmyadmin-mysql-cluster"
NAMESPACE="mysql-cluster"
MYSQL_HOST="mycluster-instances.mysql-cluster.svc.cluster.local"
BACKUP_DIR="/home/creylopez/backups"
DATE=$(date +%Y%m%d_%H%M%S)
PASS="Dsa-0213"

for DB in dbydgj40mtrjvo wpacad; do
    kubectl exec -n "$NAMESPACE" deploy/"$DEPLOYMENT" -- mysqldump --ssl-verify-server-cert=false -h "$MYSQL_HOST" -u root -p"$PASS" "$DB" | gzip > "$BACKUP_DIR/${DB}_${DATE}.sql.gz"
done

find "$BACKUP_DIR" -name "*.sql.gz" -mtime +7 -delete