#!/bin/sh
#
# --- backup_server.sh --------------------------------------------- #
# $Revision: 0.1 $ - $Author: Kreny $ - $Date: 2004/05/21 04:13:35 $ #
# ------------------------------------------------------------------ #
#
# Date, Versions & Paths 
# ------------------------------------------------------------------
# Example: 
# lrwxrwxrwx   1  root     root           41 Aug 10 08:14 mysql -> ./mysql-standard-4.1.13-pc-linux-gnu-i686
# drwxr-xr-x  14  root     mysql        4096 Aug 10 08:15 mysql-standard-4.1.13-pc-linux-gnu-i686
# lrwxrwxrwx    1 kreny    kreny          34 Jun 24 11:03 mt -> /home/kreny/mt/MT-3.0D-full-en_us/
# drwxr-xr-x   13 kreny    kreny        4096 Dec 15 01:32 MT-3.0D-full-en_us
#

# Date format: 20040626
DATE=`date -d yesterday +%Y%m%d`

# MySQL version & directory
MYSQL_VERSION="4.1.13"
#MYSQL_DIR="/usr/local/mysql/var"
MYSQL_DIR="/usr/local/mysql/data"

#MYSQL_DOWNLOAD_FILE="/home/kreny/public_html/mysql-standard-$MYSQL_VERSION-data.tgz"
MYSQL_DOWNLOAD_FOLDER="/home/kreny/public_html/download"
MYSQL_DOWNLOAD_FILE="$MYSQL_DOWNLOAD_FOLDER/mysql-standard-$MYSQL_VERSION-data-$DATE.tgz"

# MT Blog directory
# MTBLOG_VERSION="MT-3.0D-full-en_us"
MTBLOG_VERSION="MT-3.31-en_us"
#MTBLOG_DIR="/home/kreny/cgi-bin/$MTBLOG_VERSION/"
MTBLOG_DIR="/home/kreny/cgi-bin/"
MTBLOG_HTML_DIR="/home/kreny/movable_type/"

# Backup directory & Filelist
BACKUP_DIR="/var/local/backup"
BACKUP_FILELIST=$BACKUP_DIR/filelist

#
# Backup 
#

# Stop the apache if you need
#/usr/local/apache2/bin/apachectl stop

# Backup MySQL 
printf "Backuping the MySQL data directory, please wait...\n"
tar -zcpvPf $BACKUP_DIR/mysql-standard-$MYSQL_VERSION-data-$DATE.tgz $MYSQL_DIR | grep "tar:"
printf "Done! The new backup file is: $BACKUP_DIR/mysql-standard-$MYSQL_VERSION-data-$DATE.tgz\n\n"

# Make the link for downloading
rm -f $MYSQL_DOWNLOAD_FOLDER/mysql-standard-$MYSQL_VERSION-data-*.tgz
ln -s $BACKUP_DIR/mysql-standard-$MYSQL_VERSION-data-$DATE.tgz $MYSQL_DOWNLOAD_FILE

# Backup MT Blog
printf "Backuping the MT3.0 Weblog data directory, please wait...\n"
tar -zcpvPf $BACKUP_DIR/$MTBLOG_VERSION-FULL-$DATE.tgz $MTBLOG_DIR $MTBLOG_HTML_DIR | grep "tar:"
printf "Done! The new backup file is: $BACKUP_DIR/$MTBLOG_VERSION-FULL-$DATE.tgz\n"


# Delete the old files
rm -f `ls -dt /var/local/backup/mysql* |awk 'NR>5'` >> /var/log/cron
#rm -f `ls -dt /var/local/backup/MT-3.0D* |awk 'NR>5'` >> /var/log/cron
rm -f `ls -dt /var/local/backup/MT-3.3* |awk 'NR>5'` >> /var/log/cron

# Modify the permission
#chmod 777 $BACKUP_DIR/*

# Start apache 
#/usr/local/apache2/bin/apachectl start