• www.skydong.com
    #Description: Application service switch Sub
    #Notes: ~
    #———————————————————————————————————————-
    #Copyright: 2015 (c) Albert.dong
    #License: GPL
    #Database info
    DBNAME=”test1”
    DB_USER=”test001”
    DB_PASS=”Testxxxx2468!#%”
    HOST=”127.0.0.1”
    #HOST=”xxxxprerelease.mysql.rds.aliyuncs.com“
    #PORT=”3387”
    PORT=”3390”
    BACK_DIR=”/data/bak/bak_mysql/zip_mysql/“
    DATE=`date +%Y%m%d    %H%M%S`
    mkdir -p $BACKDIR
    mysqldump —opt -h$HOST -P$PORT -u$DB_USER -p$DB_PASS $DB_NAME |gzip > $BACK_DIR/$DB_NAME.test    $DATE.xxxx.gz">计划任务备份 数据库
    #!/bin/sh
    ##FileName: Backup mysql databases
    ##Revision: V1.0
    ##Date: 2015/05/25
    ##by Author: albert.dong
    ##Mailto: skydong110@gmail.com
    ##Website: www.skydong.com
    #Description: Application service switch Sub
    #Notes: ~
    #———————————————————————————————————————-
    #Copyright: 2015 (c) Albert.dong
    #License: GPL
    #Database info
    DBNAME=”test1”
    DB_USER=”test001”
    DB_PASS=”Testxxxx2468!#%”
    HOST=”127.0.0.1”
    #HOST=”xxxxprerelease.mysql.rds.aliyuncs.com“
    #PORT=”3387”
    PORT=”3390”
    BACK_DIR=”/data/bak/bak_mysql/zip_mysql/“
    DATE=`date +%Y%m%d    %H%M%S`
    mkdir -p $BACKDIR
    mysqldump —opt -h$HOST -P$PORT -u$DB_USER -p$DB_PASS $DB_NAME |gzip > $BACK_DIR/$DB_NAME.test    $DATE.xxxx.gz

    项目名称：
    修订历史：

    版本号 作者 时间
    v0.1 skydong

    计划任务备份 数据库
    #!/bin/sh
    ##FileName: Backup mysql databases
    ##Revision: V1.0
    ##Date: 2015/05/25
    ##by Author: albert.dong
    ##Mailto: skydong110@gmail.com
    ##Website: www.skydong.com
    #Description: Application service switch Sub
    #Notes: ~
    #———————————————————————————————————————-
    #Copyright: 2015 (c) Albert.dong
    #License: GPL
    #Database info
    DBNAME=”test1”
    DB_USER=”test001”
    DB_PASS=”Testxxxx2468!#%”
    HOST=”127.0.0.1”
    #HOST=”xxxxprerelease.mysql.rds.aliyuncs.com“
    #PORT=”3387”
    PORT=”3390”
    BACK_DIR=”/data/bak/bak_mysql/zip_mysql/“
    DATE=`date +%Y%m%d    %H%M%S`
    mkdir -p $BACKDIR
    mysqldump —opt -h$HOST -P$PORT -u$DB_USER -p$DB_PASS $DB_NAME |gzip > $BACK_DIR/$DB_NAME.test    $DATE.xxxx.gz