备份数据库脚本

#! /bin/sh DB_User=root DB_Passwd=ysten123 DB_Name=jira #备份目录 BackupDir=/home/jira_backup/jira_736 #获取当前日期 DATE=`date '+%Y%m%d'` function mysqlDump() { /data/mysql/bin/mysqldump --lock-tables=0 --add-drop-table -u$DB_User -p$DB_Passwd $DB_Name | gzip > $BackupDir/jira_$DATE.sql.gz mv $BackupDir/jira_$DATE.sql.gz $BackupDir/mysqldata } mysqlDump