MINI SHELL

Server : Apache/2.2.2 (Fedora)
System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686
User : apache ( 48)
PHP Version : 5.2.9
Disable Function : NONE
Directory : /usr/local/sbin/mysql_backup/

Upload File :

Current File : //usr/local/sbin/mysql_backup/mysql_db_backup.sh

#!/bin/sh
##############################

MySQL_User=sapphire
MySQL_Password=sprd!@#$%

##############################

Database_List=/usr/local/sbin/mysql_backup/mysql_db.log
Backup_log=/usr/local/sbin/mysql_backup/backup_log.log
Backup_temp=/usr/local/sbin/mysql_backup/temp
Backup_compress_dir=/var/www/html/Backup/192.168.10.4/mysql_backup
BACKUPNAME=192.168.10.4

##############################

BACKUPDATE=`date "+%d-%m-%Y"`
echo -n "Start Backup Mysql  " >> $Backup_log
date >> $Backup_log

if [ ! -e "${Backup_compress_dir}/${BACKUPNAME}_${BACKUPDATE}.tar.gz" ]; then

if [ ! -d $Backup_temp ]; then
        echo "Make Temp Dir" >> $Backup_log
        mkdir -p $Backup_temp
fi

if [ ! -d $Backup_compress_dir ]; then
        echo "Make Compress Dir" >> $Backup_log
        mkdir -p $Backup_compress_dir
fi

for i in `cat ${Database_List}`;
        do
        if [ $i != "|" ] && [ `echo $i|cut -b1` != "+" ] && [ $i != "mysql" ] && [ $i != "test" ] && [ $i != "information_schema" ]; then
        echo $i >> $Backup_log
        mysqldump --single-transaction -u ${MySQL_User} -p${MySQL_Password} $i > ${Backup_temp}/$i.sql
        fi
        done;

echo  "Compress Backup File --> ${Backup_compress_dir}/${BACKUPNAME}_${BACKUPDATE}.tar.gz " >> $Backup_log

if [ $Backup_compress_dir ]; then

tar czpf ${Backup_compress_dir}/${BACKUPNAME}_${BACKUPDATE}.tar.gz $Backup_temp

fi

if [ ! $Backup_compress_dir ]; then

tar czpf ${BACKUPNAME}_${BACKUPDATE}.tar.gz $Backup_temp

fi

if [ -e "${Backup_compress_dir}/${BACKUPNAME}_${BACKUPDATE}.tar.gz" ]; then

rm -Rf $Backup_temp
echo "Remove >> ${Backup_temp}" >> $Backup_log;

chown -R backup:sapphire ${Backup_compress_dir}/${BACKUPNAME}_${BACKUPDATE}.tar.gz
echo "Change Permission" >> $Backup_log;


else

echo "Error Compress File Faild >> ${Backup_compress_dir}/${BACKUPNAME}_${BACKUPDATE}.tar.gz" >> $Backup_log;

fi

else

echo "Error File Rady Exit >> ${Backup_compress_dir}/${BACKUPNAME}_${BACKUPDATE}.tar.gz" >> $Backup_log;


fi
echo -n "Finish Backup Mysql  " >> $Backup_log
date >> $Backup_log

Anon7 - 2021