#!/bin/bash

# Backup script to store the sql-dump of both the ECIS and BBOARD databases

# ECIS backup
mysqldump -u ecis --password=PASSWORD ecis > /var/lib/mysql/backups/nightly/ecis.sql 
tar -czvf /var/lib/mysql/backups/nightly/ecis.bckp.$( date +%Y%m%d ).sql.tar.gz /var/lib/mysql/backups/nightly/ecis.sql

# Developers BBOARD backup
mysqldump -u bboard --password=PASSWORD forum_org > /var/lib/mysql/backups/nightly/forum_org.sql 
tar -czvf /var/lib/mysql/backups/nightly/forum_org.bckp.$( date +%Y%m%d ).sql.tar.gz /var/lib/mysql/backups/nightly/forum_org.sql

# Bugzilla backup
mysqldump -u bugs bugs > /var/lib/mysql/backups/nightly/bugs.sql 
tar -czvf /var/lib/mysql/backups/nightly/bugzilla.bckp.$( date +%Y%m%d ).sql.tar.gz /var/lib/mysql/backups/nightly/bugs.sql

# Developer Site PHP nuke backup
# NOTE: nuke user doesn't really exist - can't run mysqldump as root so any userid will work here
mysqldump -u nuke nuke_org > /var/lib/mysql/backups/nightly/nuke_org.sql
tar -czvf /var/lib/mysql/backups/nightly/nuke_org.bckp.$( date +%Y%m%d ).sql.tar.gz /var/lib/mysql/backups/nightly/nuke_org.sql

# Corporate BBOARD backup
mysqldump -u bboard --password=PASSWORD forum_com > /var/lib/mysql/backups/nightly/forum_com.sql 
tar -czvf /var/lib/mysql/backups/nightly/forum_com.bckp.$( date +%Y%m%d ).sql.tar.gz /var/lib/mysql/backups/nightly/forum_com.sql

# Partner Zone backup 
mysqldump -u partners --password=PASSWORD partners > /var/lib/mysql/backups/nightly/partners.sql 
tar -czvf /var/lib/mysql/backups/nightly/partners.bckp.$( date +%Y%m%d ).sql.tar.gz /var/lib/mysql/backups/nightly/partners.sql

# Network Services backups 
mysqldump -u ecis --password=PASSWORD services > /var/lib/mysql/backups/nightly/services.sql 
tar -czvf /var/lib/mysql/backups/nightly/services.bckp.$( date +%Y%m%d ).sql.tar.gz /var/lib/mysql/backups/nightly/services.sql

# Secure server backup 
mysqldump -u root --password=PASSWORD secure > /var/lib/mysql/backups/nightly/secure.sql 
tar -czvf /var/lib/mysql/backups/nightly/secure.bckp.$( date +%Y%m%d ).sql.tar.gz /var/lib/mysql/backups/nightly/secure.sql

# Support database backup 
mysqldump -u root --password=PASSWORD support > /var/lib/mysql/backups/nightly/support.sql 
tar -czvf /var/lib/mysql/backups/nightly/support.bckp.$( date +%Y%m%d ).sql.tar.gz /var/lib/mysql/backups/nightly/support.sql

# Support KB database backup 
mysqldump -u root --password=PASSWORD support_kb > /var/lib/mysql/backups/nightly/support_kb.sql 
tar -czvf /var/lib/mysql/backups/nightly/support_kb.bckp.$( date +%Y%m%d ).sql.tar.gz /var/lib/mysql/backups/nightly/support_kb.sql

# Support KB database backup 
mysqldump -u root --password=PASSWORD esmith_broker > /var/lib/mysql/backups/nightly/esmith_broker.sql 
tar -czvf /var/lib/mysql/backups/nightly/esmith_broker.bckp.$( date +%Y%m%d ).sql.tar.gz /var/lib/mysql/backups/nightly/esmith_broker.sql

# Perform cleanup of old .sql files
rm -f /var/lib/mysql/backups/nightly/*.sql