数据库备份之冷备

#! /bin/bash
DB_HOST=”127.0.0.1″
DB_NANE=”testdatabase”
DB_USER=”root”
DB_PASS=””
DATE=`date +%Y%m%d%h%m%s`
MYSQL_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;