数据库备份之冷备

#! /bin/bashDB_HOST=“127.0.0.1"DB_NANE=“testdatabase"DB_USER=“root"DB_PASS=““DATE=date +%Y%m%d%h%m%sMYSQL_PATH=/root/back_up(){ BAKUP_FILE=${MYSQL_PATH}${DB_NAME}${DATE}.sql SQL_OPT="-u${DB_USER} -p${DB_PASS} -h${DB_HOST} ${DB_NAME}” mysqldump ${SQL_OPT} > ${BAKUP_FILE} if [ $? -eq 0 ];then echo ‘ok’; else echo ’error’; fi}back_up;