#!/bin/bash
date=`date -d "-1 day" +%Y%m%d`
backupdir="/root/backup_mysql/backup-$date/"
echo "Start to backup => `date`"
if [ ! -d $backupdir ]; then
echo "$backupdir not existing, create it now automatically"
mkdir -p $backupdir
fi
cd $backupdir
index=1
nomor=1
dbase=`mysql -uroot -ppassword -e"show databases;"`
echo $dbase | awk '{for (i = NF; i > 1; i--) print $i}' | while read line;
do
echo -n "[$index]Backup Database : `date +%H:%M:%D` $line..."
mysqldump -uroot -ppassword $line > $line.sql
if [ $? -eq 0 ]; then
echo "OK[`du -h $backupdir/$line.sql | awk '{print $1}'`]"
else
echo "Fail"
fi
index=`expr $index + 1`
done
echo "Backup finish => `date`"
echo
ls -1 $backupdir | while read line;
do
echo -n "[$nomor]Compress Database : $line.."
tar cfz $line.tar.gz $line
if [ $? -eq 0 ]; then
echo "OK[`du -h $backupdir/$line.tar.gz | awk '{print $1}'`]"
else
echo "Fail"
fi
nomor=`expr $nomor + 1`
done
echo "Compress finish => `date`"
echo "==============================================================="
rm *.sql