#!/bin/sh # File : /home/jsand/scripts/backup.mysql.db.sh # Computer: 192.168.0.1 # Use: make dump of all MySQL databases # Created : 2008.11.13 # Author : Andrey v Strukov # Changes : # 2008.12.12 - Andrey Strukov - Changed full path to 'mysql' # # Set vars (PLEASE CHANGE IF REQUIRED) bckpdir='/var/backup' bckplist='mysql_databases_list.txt' bckppath=$bckpdir/$bckplist adminemail=' admin@ep.com ' # Set formatted date dede=`date "+%d"` meme=`date "+%m"` yeye=`date "+%Y"` todaydate="$yeye$meme$dede" # Check if directory for backup not exist if test -d $bckpdir then echo "Dir exists" > /dev/null else mkdir $bckpdir fi # Creating file with databases names inside echo "show databases;" | /usr/local/bin/mysql -u root | sed '1,1d' > $bckppath # Set vars parse=`cat $bckppath` # Creating dump file of all databases /usr/local/bin/mysqldump --all-databases > $bckpdir/all-databases.sql # Creating dump files of every databases who listed in "show databases" for i in $parse do /usr/local/bin/mysqldump --databases $i > $bckpdir/$i.sql done # Creating archive with dumps # use "tar -xvf archivename.tar" for unpack tar -cvf $bckpdir/$todaydate.wwwsrv.mysqldump.tar $bckpdir/*.sql # E-mail list of completed dumps #ls -l $bckpdir/*.sql $bckpdir/*.tar | awk '{print ($5,$8,$9)}' | sort -n -r | mail -s "BACKUP.GW.MySQL" $adminemail # Cleaning up temporary directory rm -Rf $bckpdir/*.sql rm -Rf $bckpdir/$bckplist
|