1.編寫(xiě)一個(gè)備份shell腳本mysql_back.sh
!/bin/sh
File: /root/mysql_dump/mysql_back.sh
Database info
DB_NAME="dezhong_new"
DB_USER="root"
DB_PASS="Biandan@123"
Others vars
whereis mysqldump
IS ` but not '
BIN_DIR="/usr/bin"
BCK_DIR="/root/mysql_dump/data"
DATE=date +%Y%m%d_%H%M%S
TODO
mkdir -p BIN_DIR/mysqldump --opt -u
DB_PASS $DB_NAME \
DB_NAME.dump_$DATE.sql
2.crontab 定時(shí)備份
添加到crontab
crontab -e
添加一行,root用戶(hù)不需要指定執(zhí)行的用戶(hù)名,ESC,wq
表示每天8點(diǎn)和16點(diǎn)執(zhí)行備份腳本
0 8,16 * * * /root/mysql_dump/mysql_back.sh
重啟crontab服務(wù)
service crond restart
3.數(shù)據(jù)庫(kù)還原
mysql -uroot -pBiandan@123 dezhong_new < /dezhong_new.dump_20210601_085549.sql
