OpenSUSE15.3 ; Server Backup and Restore

Contents

1. Server Backup
- 1.1 Backup under /srv/www/
- 1.2. MySQL database backup
2.Restoring Data
- 2.1 Restore the backup files under /srv/www/
- 2.2 Restore MySQL data

1. Server Backup

1.1 Backup under /srv/www/

①Create a backup script file

# cd /srv/www/system/
# vi backup_all.sh

1 2	# cd /srv/www/system/ # vi backup_all.sh

Contents of www_backup.sh

#!/bin/bash

#Date processing related
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}

#!/bin/bash

#Date processing related

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

/bin/rm -f ${RUN_FLAG}

# chmod 700 www_backup.sh

1	# chmod 700 www_backup.sh

➁Create a storage directory

# mkdir -p /srv/www/backup/www_bak
# chmod 777 /srv/www/backup/www_bak

1 2	# mkdir -p /srv/www/backup/www_bak # chmod 777 /srv/www/backup/www_bak

➂Run a backup

# /srv/www/system/www_backup.sh

1	# /srv/www/system/www_backup.sh

④Add configuration to cron and backup periodically

# crontab -e
0 6 * * * /srv/www/system/www_backup.sh > /dev/null 2>&1

1 2	# crontab -e 0 6 * * * /srv/www/system/www_backup.sh > /dev/null 2>&1

1.2. MySQL database backup

①Create a backup script file

# cd /srv/www/system
# vi db_my_backup.sh

1 2	# 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" #MySQL user
MYPASS="xxxxxxx" #MySQL root 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}/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}

#!/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" #MySQL user

MYPASS="xxxxxxx" #MySQL root 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}/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

if [ -f ${DB_BAK_DIR}/${XOOPS_DB}"${DAY_AGO}".dump.gz ];

then

/bin/rm -f ${DB_BAK_DIR}/${XOOPS_DB}"${DAY_AGO}".dump.gz

if [ -f ${DB_BAK_DIR}/${GEEKLOG_DB}"${DAY_AGO}".dump.gz ];

then

/bin/rm -f ${DB_BAK_DIR}/${GEEKLOG_DB}"${DAY_AGO}".dump.gz

/bin/rm -f ${RUN_FLAG}

# chmod 700 db_my_backup.sh

1	# chmod 700 db_my_backup.sh

②Create a storage directory

# mkdir -p /srv/www/backup/db_bak
# chmod 777 /srv/www/backup/db_bak

1 2	# mkdir -p /srv/www/backup/db_bak # chmod 777 /srv/www/backup/db_bak

③Backup execution

# /srv/www/system/db_my_backup.sh

1	# /srv/www/system/db_my_backup.sh

④Set up cron to backup periodically.

# crontab -e
0 7 * * * /srv/www/system/db_my_backup.sh > /dev/null 2>&1

1 2	# crontab -e 0 7 * * * /srv/www/system/db_my_backup.sh > /dev/null 2>&1

2.Restoring Data

2.1 Restore the backup files under /srv/www/

① Save the backup file used for the restore to the server's "/ (root)" directory.

# cd /srv/www/backup/www_bak
# cp www_back_[time-stamp].tar.gz /

1 2	# 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

1 2	# cd / # tar zxvf www_back_[time-stamp].tar.gz

2.2 Restore MySQL data

① Save the database backup file to a directory of your choice.、
（In the example, the directory is "/srv/www/backup/db_bak".）Unzip the data

# cd /srv/www/backup/db_bak
# gzip -d mysql_backup_[time-stamp].dump.gz

1 2	# cd /srv/www/backup/db_bak # gzip -d mysql_backup_[time-stamp].dump.gz

② Restore the MySQL database

# mysql -u root -p < mysql_backup_[time-stamp].dump
Enter password: ←MySQL root password

1 2	# mysql -u root -p < mysql_backup_[time-stamp].dump Enter password: ←MySQL root password

Go to top