您好,登錄后才能下訂單哦!
[root@localhost?mdata]#?cat?mysql_backup.sh #!/bin/bash BACKUP_DIR=/mysql-backup DATE_DIR=`date?+%F` [?-d?$BACKUP_DIR/$DATE_DIR?]?||?mkdir?$BACKUP_DIR/$DATE_DIR?-p?&>/dev/null time="$(date?+"%Y-%m-%d")" USER= PASS= PORT= ? ? #備份數(shù)據(jù)庫(kù),全量備份 DB_LIST=$(/mdata/mysql/bin/mysql??-u$USER?-p$PASS?-P$PORT?-s?-e?"show?databases;"?2>/dev/null?|egrep?-v?"Database|information_schema|mysql|performance_schema|sys") for?DB?in?$DB_LIST;?do ???if?!?/mdata/mysql/bin/mysqldump?-u$USER?-p$PASS?$DB?>?$BACKUP_DIR/$DATE_DIR/$DB-${time}.sql?2>/dev/null;then ???echo?"$DATE_DIR???$DB-${time}.sql?備份失敗"?>>?/mdata/mysql/mysqlbackup.log ???fi done ? #刪除2天前的備份 DEL_DIR=`date?-d?"-2?days"?+%F` ? [?-d?$BACKUP_DIR/$DEL_DIR?]?&&?rm?-rf?$BACKUP_DIR/$DEL_DIR #加入計(jì)劃任務(wù) (echo?"1?01?*?*?*??/mdata/mysql/mysql_backup.sh";crontab?-l)?|crontab
注:我這里是二進(jìn)制安裝,安裝目錄也可以自己修改為變量,只做參考
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。