#!/bin/bash

SIGE_TABLES=(arzam_sige_apoio 
arzam_sige_activity_notices
arzam_sige_display_options
arzam_sige_enrollment_button_style
arzam_sige_meta_keys
arzam_sige_email_messages
arzam_sige_enrollment_status_style
arzam_sige_event_names
arzam_sige_place
arzam_sige_speakers
arzam_sige_activities
arzam_sige_enrollments
arzam_sige_cancellation_record
arzam_sige_enrollment_attendance_control
arzam_sige_confidentiality_message
arzam_sige_confidentiality_user_option
)

mysqldump -u sige --quick --extended-insert wordpress_sige2021 ${SIGE_TABLES[*]} | gzip -c > ./db_backups/backup_$(date +%F-%Hh_%Mm).sql.gz