Click here for "Error Codes for Commercial Air Conditioners".

Fedora35 : System Backup & Restore

Web configuration file (under html) backup

①Create backup script file

# cd /var/www/system/
# vi html_backup.sh
Contents of html_backup.sh

#!/bin/bash
#Date processing related (10 days saved)
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 File Related
BACKUP_DIR="/var/www/backup/html_bak" RUN_FLAG="/var/www/backup/html_bak/html_flag"

/bin/mkdir -p ${BACKUP_DIR}
/bin/touch ${RUN_FLAG}
/bin/tar vfcz ${BACKUP_DIR}/html_back_${TODAY}.tar.gz ${HTML_DIR}
/bin/chmod 644 ${BACKUP_DIR}/html_back_${TODAY}.tar.gz

if [ -f ${BACKUP_DIR}/html_back_${DAY_AGO}.tar.gz ];
then
/bin/rm -f ${BACKUP_DIR}/html_back_${DAY_AGO}.tar.gz
fi
/bin/rm -f ${RUN_FLAG}

Creation and authorization of backup storage directory

# cd /var/www/system/
# mkdir -p /var/www/backup/html_bak
# chmod 777 /var/www/backup/html_bak
# chmod 700 html_backup.sh
②Execute backup process
# /var/www/system/html_backup.sh
③Add settings to cron for periodic backups
# crontab -e
0 5 * * * /var/www/system/html_backup.sh > /dev/null 2>&1

MySQL database backup

①Create backup script file
# cd /var/www/system
# vi db_my_backup.sh
db_my_backup.shの内容

#!/bin/bash
#MYSQL Connection Settings
MYUSER="root"
MYPASS="<root password>" #MySQL connection password

#Date processing related
TIME_STRING=`/bin/date '+%Y%m%d'`
DAY_AGO=`/bin/date --date '10day ago' +%Y%m%d`

#Output File Related
DB_BAK_DIR="/var/www/backup/db_bak"  #Backup File Output Destination
RUN_FLAG="${DB_BAK_DIR}/db_my_flag"

MYSQL_BACKUP_FILE=${DB_BAK_DIR}/mysql_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}

Creation and authorization of backup storage directory

# chmod 700 db_my_backup.sh
# mkdir -p /var/www/backup/db_bak
# chmod 777 /var/www/backup/db_bak
②Execute backup process
# /var/www/system/db_my_backup.sh
③Add settings to cron for periodic backups
# crontab -e
0 7 * * * /var/www/system/db_my_backup.sh > /dev/null 2>&1

Web configuration file (under html) restored

① Copy the HTML backup file to the "/ (root)" directory of the server to be used for restoration

# cd /var/www/backup/html_bak
# cp html_back_<time-stamp>.tar.gz /

②Extract the file

# cd /
# tar zxvf html_back_<time-stamp>.tar.gz

Restore MySQL data

① Save database backup file to any directory
# cd /var/www/backup/db_bak
# gzip -d mysql_backup_<time-stamp>.dump.gz
② Restore MySQL
# mysql -u root -p < mysql_backup_<time-stamp>.dump
Enter password: ←Enter root password for MySQL
タイトルとURLをコピーしました