/date/script
数据库备份目录:/date/sqlbak
网站数据备份目录:/date/files
网站根目录:/var/www/html
> 数据库每日完整备份
#!/bin/sh
# Database info
DB_USER="root" #The mysql User
DB_PASS="rootpassword" #The mysql User Password
DB_HOST="localhost" #The Mysql Host
DB_NAME="glpi" #The Mysql Database Name For GLPI
# Others vars
BIN_DIR="/usr/bin" #The Mysql bin path
BCK_DIR="/data/sqldir" #The Backup file directory
DATE=`date +%Y-%m-%d` #Time
# TODO
# /usr/bin/mysqldump --opt -ubatsing -pbatsingpw -hlocalhost timepusher > /mnt/mysqlBackup/db_`date +%F`.sql
$BIN_DIR/mysqldump --opt -u$DB_USER -p$DB_PASS -h$DB_HOST $DB_NAME > $BCK_DIR/$DATE.sql
find $BCK_DIR -ctime +30 -name "*.*" -exec rm -rf {} \; #Delete Files 30day ago!
> 程序文件每日完整备份
#!/bin/sh
# Vars
WEB_DIR="/home/wwwroot/webdir" #the web directory path
BAK_DIR="/data/files" #the backup file directory
DATE=`date +%Y-%m-%d` #Time
# TODO
zip -r $BAK_DIR/$DATE.zip $WEB_DIR
find $BAK_DIR -ctime +30 -name "*.*" -exec rm -rf {} \; #Delete Files 30day ago!
crontab -e
00 02 * * * /date/script/sqlbak_glpi.sh #每天凌晨2点执行数据库备份脚本
30 02 * * * /date/script/webdirbak_glpi.sh #每天凌晨2点半执行网站数据备份脚本
> 虚拟机文件采取关机导出虚拟机,每月备份一次
选择存储路径完成备份
mysql -uroot -p glpi < 2017-12-29.sql
unzip 2017-12-29.zip
#覆盖网站根目录