在redhad下备份指定数据库的脚本

 

#!/bin/sh 

 

case "$1" in 

info_cms) BACKUP_FILE=/z_data_back/backup_cms_`date '+%Y%m%d_%H%M%S'`.sql ;;

info_tp) BACKUP_FILE=/z_data_back/backup_tp_`date '+%Y%m%d_%H%M%S'`.sql ;;

info_uc) BACKUP_FILE=/z_data_back/backup_uc_`date '+%Y%m%d_%H%M%S'`.sql ;;

 *) ;; 

esac 

# Start backup. 

/usr/local/mysql/bin/mysqldump --opt --password=''  -B $1 --add-drop-table -R > $BACKUP_FILE

 

# Compress backup file. 

tar -czPf $BACKUP_FILE.tar.gz $BACKUP_FILE

rm -fr  $BACKUP_FILE

 

 

移除不打包某个目录，在【Linux version 2.6.18-194.el5 (mockbuild@x86-007.build.bos.redhat.com) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-48)) #1 SMP Tue Mar 16 21:52:43 EDT 2010】系统中测试通过

 

tar -czvf ex.tar.gz --exclude /z/data/attachment /k8/data