1、备份成rar的分卷压缩格式，生成两个(若有分卷的rar压缩文件会不止两个)备份文件，如：
db20070325092032.sql，db20070325092032.sql.rar
|
#!/bin/bash
# Backup database with current date as a part of file name.
# Date: 2007-03-24
echo "Today is `date`."
echo " Now begin backup database..."
prefix=db$(date +%Y%m%d%H%M%S) # Needs a leading '+' to invoke formatting.
suffix=sql
filename=$prefix.$suffix
echo "The file name is $filename."
#Begin backup database.
hostname=yourhostname
username=yourusername
dbname=yourdbname
dbdir=~/yourdbbackupdir
mysqldump -h$hostname -u$username -p $dbname > $dbdir/$filename
#Begin compress backup file with .rar format.
compressfile=$filename.rar
echo "Begin compress $filename into $compressfile..."
cd $dbdir
rar a -v1024k $compressfile $filename
echo "Backup database success."
exit 0
|
|
**********************************************************************
2、备份成*.tar.bz2的压缩格式，生成两个备份文件，如：
db20070325092032.sql，db20070325092032.sql.tar.bz2
|
#!/bin/bash
# Backup database with current date as a part of file name.
# Date: 2007-03-24
echo "Today is `date`."
echo " Now begin backup database..."
prefix=db$(date +%Y%m%d%H%M%S) # Needs a leading '+' to invoke formatting.
suffix=sql
filename=$prefix.$suffix
echo "The file name is $filename."
#Begin backup database.
hostname=yourhostname
username=yourusername
dbname=yourdbname
dbdir=~/yourdbbackupdir
mysqldump -h$hostname -u$username -p $dbname > $dbdir/$filename
#Begin compress backup file with .tar.bz2 format.
compressfile=$filename.tar.bz2
echo "Begin compress $filename into $compressfile..."
cd $dbdir
tar cfj $compressfile $filename
echo "Backup database success."
exit 0
|
|