該腳本只適用于MYISAM引擎，如果需要適用于innodb，請修改備份命令即可。#!/bin/bash

#該腳本只能用來備份myisam引擎數據庫

#author：vaedit

#date:2017/9/18

#備份過程

function?beifen(){

BACKDIR=`date?"+%Y-%m-%d-%H"`

mkdir?/backup/$BACKDIR?-p

/usr/local/mysql/bin/mysqlhotcopy?-u?hotcopyer?-p?123456?-S?/tmp/mysql1.sock?mysql?/backup/$BACKDIR?--allowold?>?/dev/null?2>&1

#記錄日志

if?[?"$?"?-ne?0?]

then

echo?"$BACKDIR?failed"?>>/tmp/backup.log

else

echo?"$BACKDIR?ok"?>>?/tmp/backup.log

fi

#把備份通過ncftp上傳到遠端ftp服務器

cd?/backup

tar?czf?${BACKDIR}.tar.gz?$BACKDIR/*

rm?$BACKDIR?-rf

HOST='192.168.246.128'

USER='backup'

PASSWD='123456'

ncftpput?-u?$USER?-p?$PASSWD?$HOST?.?/backup/${BACKDIR}.tar.gz

}

beifen?&>/dev/null