#!/bin/bash
 
# This script was created by Dale Caon
# On the 15th of November, 2010
# for ANAT, the Australian Network for Art and Technology.
# Title : Empty Directory Cleanup Script.
# Description : This should be run to recursivly delete all empty subfolders in a directory.
# Requires : A posix compliant OS (or close). NOTE: Mac OSX does not count.
 
# Ensure that current working directory matches target dir
cd "$1"
if [ $? != 0 ];
then
        echo "Error: Failed to change directory - Exiting"
exit 1
fi
 
# find directories recursivly in current directory and output list within single quotes
# use sort to reverse order
# use xargs to convert sorted list to command line args for rmdir
# rmdir will error when removing non empty dirs therefore deleting empty dirs and leaving files intact.
 
find ./ -type d -printf "'%p'\n" | sort -r | xargs rmdir > /dev/null 2>&1

#!/bin/bash
#unset PATH
 
# USER VARIABLES
MYSQLUSER=root                         # The mysql user
MYSQLPWD='[INSERT YOUR PASSWORD]'                    # The mysql root password -- Note, might not be needed if you are using .my.cnf, but you'll need to change the script if that's the case.
MYSQLHOST=localhost                    # This should stay localhost
MYSQLBACKUPDIRTAR="backups/mysql/$HOSTNAME"            # The leading / is to be removed for TAR, otherwise it sends an annoying email each time it compresses the files.
MYSQLBACKUPDIR=/${MYSQLBACKUPDIRTAR}            # A folder where the backupped databases will be put.
EMAILADDRESS='[INSERT YOUR EMAIL ADDRESS]'                # The email address to send the backed up database to. e.g [email protected]
EMAILBODY="Attached should be the latest zipped backup of the MySQL database on $HOSTNAME"   # Where the body of the main email comes from, or the content itself.
RSYNCHOST='[[email protected]]' # This should be set to however you'd SSH into the host you want to RSYNC to. e.g [email protected]
echo "Saving compressed MySQL database backup to $MYSQLBACKUPDIR, please wait"
 
#Other Variables
CURRENTDATE=$(date '+%d-%m-%Y') #The date (e.g 23-02-2008) for use in the zip file name
MYSQLBACKUPFILENAME="MySQL_${HOSTNAME}_[$CURRENTDATE].sql" # Should look something like 'MySQL_office.anat_[23-10-2010].sql'
 
##                                                      ##
##      --       DO NOT EDIT BETWEEN THIS HERE     --   ##
##                                                      ##
 
# CREATE MYSQL BACKUP
# Create backup dir (in case it doesn't exist yet) and remove old .gz files to make way for new ones.
mkdir -p  $MYSQLBACKUPDIR
rm -v $MYSQLBACKUPDIR/*.gz
 
#Dump individual sql files... The important bit!
for i in $(echo 'SHOW DATABASES;' | mysql -u$MYSQLUSER -p$MYSQLPWD -h$MYSQLHOST | grep -v '^Database$' ); do
  mysqldump                                                    \
  -u$MYSQLUSER -p$MYSQLPWD -h$MYSQLHOST                         \
  -Q -c -C --add-drop-table --add-locks --quick --lock-tables   \
  $i > $MYSQLBACKUPDIR/$i.sql
 echo -n "."
done;
echo ""
 
##                                         ##
##      --       AND THIS HERE     --      ##
##                                         ##
## Hint, you can edit below this line      ##
 
echo "Done, dumping files to $MYSQLBACKUPDIR"
 
# This will Tarball (compress) the sql files up individually as they should get rsnapshotted, so if they haven't changed then you don't have to create a new file for them
# Note, the change directory and -C in the Tar command is to stop it from generating an annoying error saying that it's removing the leading / from the tar names.
 
cd $MYSQLBACKUPDIR/
#find * -name '*.sql' -exec tar -vcf $MYSQLBACKUPDIR/{}.tar -C / $MYSQLBACKUPDIRTAR/{} \;
# another way is to run :: find $MYSQLBACKUPDIR/ -name '*.sql' -exec tar -zvcf {}.tar.gz -C / {} \;
# The above would  tar and gzip at the same time, but I'm not sure if it's in an rsyncable way
 
## Compress the SQL files ##
find $MYSQLBACKUPDIR/ -name '*.sql' -exec gzip --best --rsyncable {} \; 
 
TARLIST=''
###  CREATE A MASTER .TAR FILE OF ALL GZIPS ####
cd $MYSQLBACKUPDIR/
# This will create a listing of all the .tar.gz files in the directory
for i in $( find * -name '*.gz' );
do
TARLIST="$TARLIST $MYSQLBACKUPDIRTAR/$i"
done;
 
# Now do that actual tarballing of the files we've listed above #
tar -vcf $MYSQLBACKUPDIR/$MYSQLBACKUPFILENAME.tar -C / $TARLIST
echo "Compressed $MYSQLBACKUPDIR/$MYSQLBACKUPFILENAME.tar"
echo
 
#### Rsync push the backed up files somewhere ####
rsync -avh $MYSQLBACKUPDIR/*.gz -e ssh $RSYNCHOST:/backup/mysql/$HOSTNAME/
## Note, you might need to create the directory on the target server, or maybe change to something like /backup/mysql/$HOSTNAME and hopefully the parent directory already exists.
echo "---"
echo "Rsync'd daily backup"
 
### Mail the zipped file as an attachment... If your database is too big you'll have to replace this with rsync, or FTP backup ##
echo $EMAILBODY | mutt -s "[$HOSTNAME] DailyMysql backup" -a $MYSQLBACKUPDIR/$MYSQLBACKUPFILENAME.tar -- $EMAILADDRESS
echo "emailed the zipped file"
 
### All databases in one file, Emergency Backup in case they all die ###
# mysqldump --add-drop-database --all-databases > $MYSQLBACKUPDIR/allMySQL-current.sql
# gzip --rsyncable $MYSQLBACKUPDIR/allMySQL-current.sql
# echo "Finished the all in one backup $MYSQLBACKUPDIR/allMySQL-current.sql.gz"
 
# Before Rsnapshot decides to copy all of this lets remove the unwanted files
#rm $MYSQLBACKUPDIR/*.sql # Don't need to remove them as they've already been converted to .tar.gz files
rm $MYSQLBACKUPDIR/$MYSQLBACKUPFILENAME.tar
rm $MYSQLBACKUPDIR/*.sql
 
echo
echo "Listing of compressed files in $HOSTNAME:$MYSQLBACKUPDIR"
echo "------------------------------------------------------------------"
ls -Asch1 $MYSQLBACKUPDIR/
echo "---"
echo "DONE!"

alias aRestart='sudo apache2ctl -k restart'
alias acs='apt-cache search'
alias agg='sudo apt-get upgrade'
alias agi='sudo apt-get install'
alias agr='sudo apt-get remove'
alias agu='sudo apt-get update'
alias apt='sudo apt-get install'
alias aliasd='nano ~/.bash_aliases'
alias alogs='sudo tail -f /var/log/apache2/access_logs/*_log /var/log/apache2/error_logs/*_log'
alias bashrc='nano ~/.bashrc'
alias cdetca='cd /etc/apache2/sites-available'
alias cdwww='cd /var/www/'
alias chownWWW='sudo chown -Rc www-data:www-data * .htaccess'
alias da='du -hsc *'
alias dir='ls --color=auto --format=vertical'
alias directoryExec='sudo find * -type d -exec chmod -c ug+x {} \;'
alias ds='du -hsc * | sort -n'
alias egrep='egrep --color=auto'
alias eximQ='sudo exim -bp'
alias eximRemove='exim -Mrm'
alias eximRouting='exim -bt'
alias eximStats='eximstats -nr /var/log/exim4/mainlog'
alias fgrep='fgrep --color=auto'
alias grep='grep --color=auto'
alias l='ls -CF'
alias la='ls -A --color=auto'
alias ldir='ls -l | egrep '\''^d'\'''
alias lf='ls -l | egrep -v '\''^d'\'''
alias ll='ls -Alsch --color=auto'
alias load='uptime'
alias logs='find /var/log/ -name "*.log" -type f -exec tail -f {} +'
alias logsudo='sudo find /var/log/  -name "*.log" -type f -exec sudo tail -f {} +'
alias ls='ls --color=auto'
alias maillog='tail -n 50 -f /var/log/exim4/mainlog /var/log/exim4/rejectlog'
alias mailstats='eximstats /var/log/exim4/mainlog'
alias mem='free -m'
alias netstats='sudo netstat -tulpn'
alias openz='gzip -d -c'
alias rm='rm -v'
alias rma='rm -Rv'
alias vdir='ls --color=auto --format=long'

alias directoryExec='for directory in "$( sudo find * -type d )"
do
sudo chmod -c ug+x $directory
done'

###################################
## Script to add new logs to existing web stats ##
###################################
 
BASE_OUTPUT_DIR='/home/anat/public_html/webstats/'
BASE_LOGS_DIR='/var/log/apache2/access_logs/'
LOGS_APPENDED_CHARS='_log.1'
SED_LOGS_DIR=${BASE_LOGS_DIR//\//\\\/}                #Replace / with \/ to get around SED regex substitution
SED_LOGS_APPENDED_CHARS=${LOGS_APPENDED_CHARS/\./\\.}            # Like above but replace . with \.
for LOG in $( find "$BASE_LOGS_DIR" -name "*$SED_LOGS_APPENDED_CHARS"  -type f )
do
SITE=`echo "$LOG" | sed -e "s/$SED_LOGS_DIR//" -e "s/$SED_LOGS_APPENDED_CHARS//" `
mkdir -p $BASE_OUTPUT_DIR$SITE/
webalizer -o $BASE_OUTPUT_DIR$SITE/ -n $SITE $LOG
done