#!/bin/bash

#Backing up the Analytica Wiki
#create sql dump for the wiki
mysqldump --default-character-set=latin1 --user=mediawiki --password=lum!na!0 'mwdatabase' > /home/analytica/mwDatabase
#create tar.gz for all the wiki files
tar -czf /home/analytica/mwFiles /var/www/html/wiki/

#Backing up the Lumina.com EE website
#EE database
mysqldump --default-character-set=latin1 --user=root --password=Password1 'lumina_ee' > /home/analytica/eeDatabase
#EE files
tar -czf /home/analytica/eeFiles /var/www/html/ --exclude=wiki


#Backing up the Analytica Blog
#WordPress database
mysqldump --default-character-set=latin1 --user=root --password=Password1 'wordpress' > /home/analytica/wpDatabase
#WordPress files
tar -czf /home/analytica/wpFiles /var/www/blog/