#!/bin/sh
databases=()

backup_dir=/root/db_dump

if [ ! -d $backup_dir ]; then
  mkdir -p $backup_dir
fi

cd $backup_dir

for name in ${databases[@]}
do
  for j in 7 6 5 4 3 2 1 0; do
    for i in $name.$j; do
      if [ -e $i.sql.bz2 ]; then
        mv $i.sql.bz2 ${i/.$j/}.$(( $j + 1 )).sql.bz2;
      fi
    done
  done

  mysqldump -u user -pPASS $name > ./$name.0.sql
  bzip2 -z $name.0.sql
done