#!/bin/bash
archive="/myth/DBbackup"
db="mythconverg"
hourly="24"
daily="7"
weekly="6"
monthly="12"

cd $archive
if [ "$1" = "hourly" ]; then
 x=`expr $hourly - 1`
fi
if [ "$1" = "daily" ]; then
 x=`expr $daily - 1`
fi
if [ "$1" = "weekly" ]; then
 x=`expr $weekly - 1`
fi
if [ "$1" = "monthly" ]; then
 x=`expr $monthly - 1`
fi

while [ "$x" -gt "1" ]
do
  y=`expr $x - 1`
  if [ -e $1$db.$y.sql.bz2 ]; then
    mv -f $1$db.$y.sql.bz2 $1$db.$x.sql.bz2
  fi
  x=$y
done
if [ -e $1$db.sql.bz2 ]; then
  mv -f  $1$db.sql.bz2  $1$db.1.sql.bz2
fi

mysqldump $db >$1$db.sql
bzip2 -9 $1$db.sql