# backup
23 0    * * 1-6 root    /usr/local/sbin/backup.sh
23 0    * * 7   root    /usr/local/sbin/backup.sh --full

00 4 *   *   *   /usr/local/bin/ftplicity backup && /usr/local/bin/ftplicity purge --force

00 6 1   *   *   /usr/local/bin/ftplicity full && /usr/local/bin/ftplicity purge --force

#!/bin/sh

DATUM=`date +'%Y-%m-%d'`
MYSQLDUMP=/usr/bin/mysqldump
FIND=/usr/bin/find
RM=/bin/rm
GZIP=/bin/gzip
NICE=/usr/bin/nice
BASENAME=/usr/bin/basename

#solange wird der dump behalten
LIFETIME=7

cd /root/backup/mysql

for i in `$FIND /var/lib/mysql/* -maxdepth 0 -type d -exec $BASENAME {} ';'`; do
  echo -n "saving $i ...."
  $NICE $MYSQLDUMP --defaults-file=/etc/mysql/debian.cnf --databases $i  > $DATUM-$i.sql
  $RM -f $DATUM-$i.sql.gz
  $NICE $GZIP -9 $DATUM-$i.sql
  echo "done."
done


#delete old files
$FIND . -type f -ctime +$LIFETIME -exec $RM -f {} ';'

mysqlshow -u BENUTZER -pPASSWORT | awk '{print $2}' | grep -v Databases | sort >/root/script/dbaselist.txt
cd /root/mysqlbackup
for x in `cat /root/script/dbaselist.txt`; do
    echo "Datenbank: $x sichern";
    mysqldump --opt -pPASSWORT $x >$x.sql;
   done;
   echo "Alte .gz-Dateien loeschen:"
   rm *.gz
   echo "Dateien zippen:"
   gzip *
   echo

hossie@tuxy ~ $ wget http://ftp.uni-kl.de/pub/linux/knoppix/DVD/packages-dvd.txt -O - -q | grep ftplicity -c
0