东莞网站设计行情,html网站模板下载,网页在线小游戏,seo北京该脚本只适用于MYISAM引擎#xff0c;如果需要适用于innodb#xff0c;请修改备份命令即可。#!/bin/bash#该脚本只能用来备份myisam引擎数据库#author#xff1a;vaedit#date:2017/9/18#备份过程function beifen(){BACKDIRdate %Y-%m-%d-%Hmkdir /backup/$BACKD…该脚本只适用于MYISAM引擎如果需要适用于innodb请修改备份命令即可。#!/bin/bash#该脚本只能用来备份myisam引擎数据库#authorvaedit#date:2017/9/18#备份过程function beifen(){BACKDIRdate %Y-%m-%d-%Hmkdir /backup/$BACKDIR -p/usr/local/mysql/bin/mysqlhotcopy -u hotcopyer -p 123456 -S /tmp/mysql1.sock mysql /backup/$BACKDIR --allowold /dev/null 21#记录日志if [ $? -ne 0 ]thenecho $BACKDIR failed /tmp/backup.logelseecho $BACKDIR ok /tmp/backup.logfi#把备份通过ncftp上传到远端ftp服务器cd /backuptar czf ${BACKDIR}.tar.gz $BACKDIR/*rm $BACKDIR -rfHOST192.168.246.128USERbackupPASSWD123456ncftpput -u $USER -p $PASSWD $HOST . /backup/${BACKDIR}.tar.gz}beifen /dev/null