USER=""
PASSWORD=""
HOST="ftp.lima-city.de"
DB_USER=""
DB_PASSWORD=""
DB_HOST="mysql.lima-city.de"
DATABASE='-A'
DL_USER=""
DL_PASSWORD=""
DL_HOST="download.lima-city.de"
DL=0
DIR='./files/'
DATE=$(date +'%Y-%m-%d_%H-%M-%S')
if [ ! -d $DIR ] ; then
mkdir $DIR
fi
echo "Deleting old backups..."
for i in $(find "$DIR" -iname '*.sql.bz2' | sort -rf | head -n-4) ; do
rm -v "$i"
done
for i in $(find "$DIR" -iname '*_webspace.tar.bz2' | sort -rf | head -n-4) ; do
rm -v "$i"
done
for i in $(find "$DIR" -iname '*_download.tar.bz2' | sort -rf | head -n-4) ; do
rm -v "$i"
done
if [ ! "$DATABASE" = '-A' ] ; then
DATABASE="--databases $DATABASE"
fi
echo "Saving MySQL backup..."
mysqldump --lock-tables=false -u$DB_USER -h$DB_HOST -p$DB_PASSWORD $DATABASE | \
bzip2 > ${DIR}${DATE}.sql.bz2
echo "Backup saved as '$DIR$DATE.sql.bz2'"
echo "Making backup of Webspace..."
mkdir tmp
cd tmp
lftp -u "$USER:$PASSWORD" $HOST -e 'mirror . ; quit'
tar cavf "../${DIR}${DATE}_webspace.tar.bz2" *
cd ..
rm -rf tmp
echo "Backup saved as ${DIR}${DATE}_webspace.tar.bz2"
if [ $DL -eq 1 ] ; then
echo "Backing Up Download-Server..."
mkdir tmp
cd tmp
FILES=$(lftp -u "$DL_USER:$DL_PASSWORD" $DL_HOST -e 'find ; quit' | \
sed -rn 's_^\./(.+[^/ ])\s*$_\1_p')
for i in $FILES ; do
d="./${i%$(basename $i)}"
[ ! -d "$d" ] && mkdir "$d"
wget "http://download.lima-city.de/$USER/$i" -O "$i"
done
tar cavf "../${DIR}${DATE}_download.tar.bz2" *
cd ..
rm -rf tmp
echo "Backup saved as ${DIR}${DATE}_download.tar.bz2"
fi