#!/bin/sh

cd /home/supercheats/supercheats.com/php/cron
rsync -av --delete /home/supercheats/supercheats.com/ /home/supercheats/backup/site/

mv /home/supercheats/backup/mysql/supercheats_forum_db_backup.sql /home/supercheats/backup/mysql/supercheats_forum_db_backup.sql.prev
mv /home/supercheats/backup/mysql/supercheats_walkthrough_db_backup.sql /home/supercheats/backup/mysql/supercheats_walkthrough_db_backup.sql.prev
mv /home/supercheats/backup/mysql/supercheats_wiki_db_backup.sql /home/supercheats/backup/mysql/supercheats_wiki_db_backup.sql.prev
mv /home/supercheats/backup/mysql/supercheats_reports_db_backup.sql /home/supercheats/backup/mysql/supercheats_reports_db_backup.sql.prev
mv /home/supercheats/backup/mysql/supercheats_mods_db_backup.sql /home/supercheats/backup/mysql/supercheats_mods_db_backup.sql.prev
mv /home/supercheats/backup/mysql/pokedex_db_backup.sql /home/supercheats/backup/mysql/pokedex_db_backup.sql.prev
mv /home/supercheats/backup/mysql/latestscreens_db_backup.sql /home/supercheats/backup/mysql/latestscreens_db_backup.sql.prev

mysqldump -u dumpuser -pU]Q:9pd]b92sGk3F --lock-tables=false supercheats_forum > /home/supercheats/backup/mysql/supercheats_forum_db_backup.sql
mysqldump -u dumpuser -pU]Q:9pd]b92sGk3F --lock-tables=false supercheats_walkthrough > /home/supercheats/backup/mysql/supercheats_walkthrough_db_backup.sql
mysqldump -u dumpuser -pU]Q:9pd]b92sGk3F --lock-tables=false supercheats_wiki > /home/supercheats/backup/mysql/supercheats_wiki_db_backup.sql
mysqldump -u dumpuser -pU]Q:9pd]b92sGk3F --lock-tables=false supercheats_reports > /home/supercheats/backup/mysql/supercheats_reports_db_backup.sql
mysqldump -u dumpuser -pU]Q:9pd]b92sGk3F --lock-tables=false supercheats_mods > /home/supercheats/backup/mysql/supercheats_mods_db_backup.sql
mysqldump -u dumpuser -pU]Q:9pd]b92sGk3F --lock-tables=false pokedex pokedex_v3 > /home/supercheats/backup/mysql/pokedex_db_backup.sql
mysqldump -u dumpuser -pU]Q:9pd]b92sGk3F --lock-tables=false latestscreens > /home/supercheats/backup/mysql/latestscreens_db_backup.sql