- #!/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
|
