#!/bin/bash

#Script. Name:testDBdailytable.sh

#Create Time:2012-06-05

#define backup DBName

myDB=testDB

#define scriptdir

scriptdir=`pwd`

backupdir=testDBbackup/testDBDailytable

#define time 2 days ago

DATE=`date +%Y_%m_%d --date '2 days ago'`

tmp="user_log"

tablename=${tmp}_${DATE}

var=$(date +"%y-%m-%d %H:%M:%S")

#define backupfile format

baktabtable=${tablename}.$(date +%y%m%d).tar.gz

cd ${backupdir}

if [ -f ${baktabformat} ];then

var="${var}
[${baktableformat}] table exists cannot backup again"

else

/usr/bin/mysqldump -h xx.xx.xx.xx -P port -uxyz -p'xxxxx' ${myDB} ${tablename} > ${backupdir}/${tablename}.sql

#tar backup file

if [ $? == 0 ];then

cd ${backupdir}

tar -jcf ${tablename}.$(date +%y%m%d).tar.bz2 ${tablename}.sql

var="${var}
BackuptableName:${baktabformat}"

rm ${tablename}.sql

fi

ITPub博客

每天备份一次DB中table