使用mysqldump对数据库定时备份脚本

脚本`dbbackup.sh`，放在`/home/data/backup/`下：
```
#!/bin/bash

rootPath=/home/data/backup
tempPath=$rootPath/temp
curDate="$(date '+%Y-%m-%d %H:%M:%S')"
zipName="dbbackup_$(date '+%Y%m%d%H%M%S').sql.tar.gz"
username=zwb
password=******
echo "$curDate[INFO]Start=============================================================..." >> run.log
echo "$curDate[INFO]Startting database backup..." >> run.log
cd $rootPath
if [ ! -d $rootPath/temp ]; then
    mkdir $rootPath/temp
fi

echo "$curDate[INFO]Startting backup zwb..." >> run.log
`mysqldump -u$username -p$password -h 192.168.8.140 --databases zwb > $tempPath/backup-zwb.sql`
if [ ! -f $tempPath/backup-zwb.sql ]; then
    echo "$curDate[ERROR]Backup batabase zwb failed." >> run.log
    exit 1
fi

echo "$curDate[INFO]Startting backup esb..." >> run.log
`mysqldump -u$username -p$password -h 192.168.8.140 --databases esb > $tempPath/backup-esb.sql`
if [ ! -f $tempPath/backup-esb.sql ]; then
    echo "$curDate[ERROR]Backup batabase esb failed." >> run.log
    exit 1
fi

echo "$curDate[INFO]Startting backup knowledge..." >> run.log
`mysqldump -u$username -p$password -h 192.168.8.140 --databases knowledge > $tempPath/backup-knowledge.sql`
if [ ! -f $tempPath/backup-knowledge.sql ]; then
    echo "$curDate[ERROR]Backup batabase knowledge failed." >> run.log
    exit 1
fi

echo "$curDate[INFO]Startting backup nacos..." >> run.log
`mysqldump -u$username -p$password -h 192.168.8.140 --databases nacos > $tempPath/backup-nacos.sql`
if [ ! -f $tempPath/backup-nacos.sql ]; then
    echo "$curDate[ERROR]Backup batabase nacos failed." >> run.log
    exit 1
fi

cd $tempPath
tar zcvf ../$zipName *.sql
cd $rootPath
if [ -f $zipName ]; then
    rm -rf temp/backup-zwb.sql
    rm -rf temp/backup-esb.sql
    rm -rf temp/backup-knowledge.sql
    rm -rf temp/backup-nacos.sql
    echo "$curDate[INFO]Backup sucessful." >> run.log
else 
    echo "$curDate[ERROR]File compression failed." >> run.log
    exit 1
fi

cd $rootPath
echo "$curDate[INFO]Database backup finished." >> run.log
echo "$curDate[INFO]End=============================================================..." >> run.log
exit 0

```