#!/bin/sh
#make a bz2 tar of the gameDB
cd /PWServer/146/gamedbd/dbdata/
tar -cjf /gameDB.bz2 *
#make a bz2 tar of the unameDB
cd /PWServer/146/uniquenamed/dbdata/
tar -cjf /unameDB.bz2 *
#backup mysqlDB too
cd /opt/lampp/bin/
./mysqldump --opt -Q --routines -uroot -proot "dbo" > /dboMySQL.sql
#archive with timestamp
cd /
mkdir /BACKUP_ARCHIVE
archive_name=gameDB.bz2
archive2_name=unameDB.bz2
archive3_name=dboMySQL.sql
current_time=$(date "+%Y.%m.%d-%H.%M.%S")
new_filename=$archive_name.$current_time
new2_filename=$archive2_name.$current_time
new3_filename=$archive3_name.$current_time
cp $archive_name $new_filename
cp $archive2_name $new2_filename
cp $archive3_name $new3_filename
mv $new_filename /BACKUP_ARCHIVE
mv $new2_filename /BACKUP_ARCHIVE
mv $new3_filename /BACKUP_ARCHIVE
mv gameDB.bz2 /BACKUP_ARCHIVE
mv unameDB.bz2 /BACKUP_ARCHIVE
mv dboMySQL.sql /BACKUP_ARCHIVE