1. Server backup
1.1 Backup of the /srv/www/ directory
①Creating a Backup Script File
# cd /srv/www/system/
# vi www_backup.sh
Contents of www_backup.sh
#!/bin/bash
#Date Processing
TODAY=`/bin/date +%Y%m%d`
DAY_AGO=`/bin/date --date '7day ago' +%Y%m%d`
#Backup source
HTDOCS_DIR="/srv/www/htdocs"
SYSTEM_DIR="/srv/www/system"
#Output file
BACKUP_DIR="/srv/www/backup/www_bak" #Backup file output destination
RUN_FLAG="/srv/www/backup/www_bak/www_flag"
/bin/mkdir -p ${BACKUP_DIR}
/bin/touch ${RUN_FLAG}
/bin/tar vfcz ${BACKUP_DIR}/www_back_${TODAY}.tar.gz ${HTDOCS_DIR} ${SYSTEM_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}
# chmod 700 www_backup.sh
➁Create the directory to store
# mkdir -p /srv/www/backup/www_bak
# chmod 777 /srv/www/backup/www_bak
➂Perform a backup
# /srv/www/system/www_backup.sh
④Add a setting to cron to perform regular backups
# crontab -e
0 6 * * * /srv/www/system/www_backup.sh > /dev/null 2>&1
1.2. MariaDB Database Backup
①Creating a Backup Script File
# cd /srv/www/system
# vi db_my_backup.sh
Contents of db_my_backup.sh
#!/bin/bash
export LANG=ja_JP.eucJP
export PATH="$PATH":/usr/local/mysql/bin
export MYSQL_HOME=/usr/local/mysql
export MYLIB=${MYSQL_HOME}/lib
export MANPATH="${MANPATH}":${MYSQL_HOME}/man
export LD_LIBRARY_PATH="${LD_LIBRARY_PATH}":"${MYLIB}"
MYUSER="root" #MariaDB connection username
MYPASS="xxxxxxx" #MariaDB connection password
TIME_STRING=`/bin/date '+%Y%m%d'`
DAY_AGO=`/bin/date --date '10day ago' +%Y%m%d`
DB_BAK_DIR="/srv/www/backup/db_bak"
RUN_FLAG="${DB_BAK_DIR}/db_my_flag"
MYSQL_BACKUP_FILE=${DB_BAK_DIR}/mariadb_backup_"${TIME_STRING}".dump
/bin/mkdir -p ${DB_BAK_DIR}
/bin/touch ${RUN_FLAG}
mysqldump -u${MYUSER} -p${MYPASS} --all-databases > ${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}
# chmod 700 db_my_backup.sh
➁Create the directory to store
# mkdir -p /srv/www/backup/db_bak
# chmod 777 /srv/www/backup/db_bak
③Backup execution
# /srv/www/system/db_my_backup.sh
④Set up a cron job to perform regular backups.
# crontab -e
0 7 * * * /srv/www/system/db_my_backup.sh > /dev/null 2>&1
2.Data Recovery
2.1 Restoring Backup Files Under www
① Save the backup file used for restoration to the server's "/" (root) directory.
# cd /srv/www/backup/www_bak
# cp www_back_[time-stamp].tar.gz /
② Extract the file
# cd /
# tar zxvf www_back_[time-stamp].tar.gz
2.2 Restore MariaDB data
① Save the database backup file to any directory and unzip the data
# cd /srv/www/backup/db_bak
# gzip -d mariadb_backup_[time-stamp].dump.gz
② Restore the MariaDB database
# mysql -u root -p < mariadb_backup_[time-stamp].dump
Enter password: ←MariaDB root Password
