嵌入式下MySQL增量备份解决方案

引用:

#mount.sh

#!/bin/bash

set -e
dataDir=/opt/lampp/var/mysql
backupDir=/opt/lampp/var/mysqldata
plusDir=/opt/lampp/backup/mysql/daily
SqlUser=root
SqlPass=kai089hong

if [ ! -e $plusDir ]
then
mkdir -p $plusDir
fi

test -f /etc/init.d/nasa_switch || exit 0
case "$1" in

start)

echo -n "Starting NASA Server ......"
if [ -d $dataDir ]
then
mount -t tmpfs -o size=32m tmpfs $dataDir
else
mkdir -p $dataDir
mount -t tmpfs -o size=32m tmpfs $dataDir
fi
echo -e "\nMount tmpfs successfully!\n"
cp -R $backupDir/mysql $dataDir/
chmod -R 777 $dataDir
chown -R nobody $dataDir
sleep 4
/opt/lampp/lampp start >/dev/null 2>&1 && echo -e "\nStarted XAMPP successfully!\n"
sleep 4
/opt/lampp/bin/mysqladmin -u$SqlUser -p$SqlPass CREATE nasa > /dev/null
SqlFile=/opt/lampp/backup/mysql
SqlName=`cat $SqlFile/lastone`
/opt/lampp/bin/mysql -u$SqlUser -p$SqlPass nasa < $SqlFile/$SqlName
/opt/lampp/bin/mysqlbinlog $plusDir/mysql-bin.*|mysql -uroot -pkai089hong nasa > /dev/null 2>&1
sleep 3
/opt/lampp/bin/backup.sh
echo -e "\nRecover data successfully!\n"
sleep 10
;;

stop)

echo -e "Stopping NASA Server .......\n"
/opt/lampp/bin/add.sh
sleep 5
/opt/lampp/lampp stop >/dev/null 2>&1
umount $dataDir >/dev/null 2>&1
#mv $backupDir $dataDir
#/opt/lampp/lampp restart >/dev/null 2>&1
#/opt/lampp/bin/mysqlbinlog $plusDir/mysql-bin.*|mysql -uroot -pkai089hong nasa
#mv $dataDir $backupDir
sleep 10
echo -e "OK\n"

;;

*)

echo "Usage: /etc/init.d/nasa_switch {start|stop}"

exit 1

esac

exit 0

bakup.sh
#!/bin/bash

BakDir=/opt/lampp/backup/mysql
LogFile=/opt/lampp/backup/mysql/mysqlbak.log
CatFile=/opt/lampp/backup/mysql/lastone
DailyBakDir=$BakDir/daily
DATE=`date +%y%m%d%H%M%S`
SqlUser=root
SqlPass=kai089hong


if [ ! -e $DailyBakDir ]
then
mkdir -p $DailyBakDir
fi

echo " " >> $LogFile
echo " " >> $LogFile
echo "-------------------------------------------" >> $LogFile
echo $(date +"%y-%m-%d %H:%M:%S") >> $LogFile
echo "--------------------------" >> $LogFile


cd $BakDir
DumpFile=$DATE
echo $DumpFile>$CatFile
/opt/lampp/bin/mysqldump --flush-logs --delete-master-logs --lock-all-tables nasa -u$SqlUser -p$SqlPass>$DumpFile
echo "Dump Done" >> $LogFile

echo "[$DumpFile]Backup Success!" >> $LogFile

cd $DailyBakDir
rm -f *

cd $BakDir
echo "Backup Done!"
echo "please Check $BakDir Directory!"
echo "copy it to your local disk or ftp to somewhere !!!"

ls -al $BakDir

#add.sh

#!/bin/bash
#
# mysql binlog backup script
#


DATADIR=/opt/lampp/var/mysql
BAKDIR=/opt/lampp/backup/mysql/daily
SqlUser=root
SqlPass=kai089hong
/opt/lampp/bin/mysqladmin flush-logs -u$SqlUser -p$SqlPass

if [ ! -e "$BAKDIR" ]
then
mkdir $BAKDIR
fi

cd $DATADIR

FILELIST=`cat mysql-bin.index`

COUNTER=0
for file in $FILELIST
do
COUNTER=`expr $COUNTER + 1`
done

NextNum=0
for file in $FILELIST
do
base=`basename $file`
NextNum=`expr $NextNum + 1`
if [ $NextNum -eq $COUNTER ]
then
echo "skip lastest"
else
dest=$BAKDIR/$base
if [ -e $dest ]
then
echo "skip exist $base"
else
echo "copying $base"
cp $base $BAKDIR
fi
fi
done
#cp $DATADIR/mysql-bin.index $BAKDIR
echo "backup mysql binlog ok"