1. System backup
1.1 Backup under /var/www/html
①Create the backup_all.sh script under /opt/script/
# vi /opt/script/backup_all.sh
backup_all.sh script contents
10-day data retention
#!/bin/bash
#Date-related processing
TODAY=`/bin/date +%Y%m%d`
DAY_AGO=`/bin/date --date '10day ago' +%Y%m%d`
#Backup Source Related
HTML_DIR="/var/www/html"
#Output Files
BACKUP_DIR="/var/www/backup/www_bak" #Backup file destination
RUN_FLAG="/var/www/backup/www_bak/www_flag"
# Backup process
/bin/mkdir -p ${BACKUP_DIR}
/bin/touch ${RUN_FLAG}
/bin/tar vfcz ${BACKUP_DIR}/www_back_${TODAY}.tar.gz ${HTML_DIR}
/bin/chmod 644 ${BACKUP_DIR}/www_back_${TODAY}.tar.gz
if [ -f ${BACKUP_DIR}/www_back_${DAY_AGO}.tar.gz ];
then
/bin/rm -f ${BACKUP_DIR}/www_back_${DAY_AGO}.tar.gz
fi
/bin/rm -f ${RUN_FLAG}
➁Create a directory to store backup files
# chmod 777 /opt/script/backup_all.sh
# mkdir -p /var/www/backup/www_bak
# chmod 777 /var/www/backup/www_bak
➂Add a setting to cron to perform regular backups.
# crontab -e
0 6 * * * /opt/script/backup_all.sh > /dev/null 2>&1
1.2 MySQL Database Backup
①Create the db_backup.sh script under /opt/script
# vi /opt/script/db_backup.sh
db_backup.sh script contents
#!/bin/bash
export LANG=ja_JP.eucJP
export PATH="$PATH":/usr/bin
export MYSQL_HOME=/etc/mysql
export MYLIB=/usr/lib/mysql
export MANPATH=":wq/usr/share/man"
export LD_LIBRARY_PATH="${LD_LIBRARY_PATH}":"MYLIB"
# MySQL Connection Settings
MYUSER="root" # MySQL connection username
MYPASS="********" # MySQL connection password
#Date-related processing
TIME_STRING=`/bin/date '+%Y%m%d'`
DAY_AGO=`/bin/date --date '10day ago' +%Y%m%d`
# Output Files
DB_BAK_DIR="/var/www/backup/db_bak" # Backup file destination
RUN_FLAG="${DB_BAK_DIR}/db_my_flag"
MYSQL_BACKUP_FILE=${DB_BAK_DIR}/mysql_backup_"${TIME_STRING}".dump
#Backup process
/bin/mkdir -p ${DB_BAK_DIR}
/bin/touch ${RUN_FLAG}
mysqldump -u${MYUSER} -p${MYPASS} --all-databases --events > ${MYSQL_BACKUP_FILE}
/bin/gzip ${MYSQL_BACKUP_FILE}
if [ -f ${DB_BAK_DIR}/${MT_DB}"${DAY_AGO}".dump.gz ];
then
/bin/rm -f ${DB_BAK_DIR}/${MT_DB}"${DAY_AGO}".dump.gz
fi
if [ -f ${DB_BAK_DIR}/${XOOPS_DB}"${DAY_AGO}".dump.gz ];
then
/bin/rm -f ${DB_BAK_DIR}/${XOOPS_DB}"${DAY_AGO}".dump.gz
fi
if [ -f ${DB_BAK_DIR}/${GEEKLOG_DB}"${DAY_AGO}".dump.gz ];
then
/bin/rm -f ${DB_BAK_DIR}/${GEEKLOG_DB}"${DAY_AGO}".dump.gz
fi
/bin/rm -f ${RUN_FLAG}
➁Create a directory to store backup files
# chmod 777 /opt/script/db_backup.sh
# mkdir -p /var/www/backup/db_bak
# chmod 777 /var/www/backup/db_bak
③Add a setting to cron to perform regular backups.
# crontab -e
0 7 * * * /opt/script/db_backup.sh > /dev/null 2>&1
2. System Restore
2.1 Restoring Backup Files Under HTML
Store the HTML backup file used for backups in the "/" (root) directory.
Select the backup file with the most recent timestamp.
# cd /var/www/backup/www_bak
# cp www_back_xxxxxxxx.tar.gz /
# cd /
# tar zxvf www_back_xxxxxxxx.tar.gz
2.2 Restore MySQL Database
①Save the DB backup file to any directory and extract the data.
# cd /var/www/backup/db_bak
# gzip -d mysql_backup_xxxxxxxx.dump.gz
②Restore MySQL
# mysql -u root -p < mysql_backup_xxxxxxxx.dump
Enter password: ←MySQL root password