{"id":227533,"date":"2014-06-25T11:10:02","date_gmt":"2014-06-25T07:10:02","guid":{"rendered":"http:\/\/savepearlharbor.com\/?p=227533"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=227533","title":{"rendered":"\u0411\u0435\u043a\u0430\u043f \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u2013 \u0435\u0441\u0442\u044c \u043b\u0438 \u043e\u043d?<\/span>"},"content":{"rendered":"
\t\"image\"\/<\/p>\n

\u041d\u0435\u0442 \u0441\u043c\u044b\u0441\u043b\u0430 \u0433\u043e\u0432\u043e\u0440\u0438\u0442\u044c \u043e \u0442\u043e\u043c, \u043d\u0430\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u044d\u0442\u043e \u0430\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0432\u043e\u043f\u0440\u043e\u0441. \u0421\u0435\u0433\u043e\u0434\u043d\u044f \u043c\u044b \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0435\u043c, \u043a\u0430\u043a \u0443 \u043d\u0430\u0441 \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u043e\u0432\u0430\u043d\u043e \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0435 \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 mysql.
\u0418 \u043e\u0434\u043d\u043e \u0438\u0445 \u0441\u0430\u043c\u044b\u0445 \u0432\u0430\u0436\u043d\u044b\u0445 \u2013 \u044d\u0442\u043e \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0430, \u0430 \u0441\u0434\u0435\u043b\u0430\u043b\u0441\u044f \u043b\u0438 \u0431\u0435\u043a\u0430\u043f? \u0410 \u0443\u0441\u043f\u0435\u0448\u043d\u043e \u043b\u0438 \u043f\u0440\u043e\u0448\u0435\u043b \u0434\u0430\u043c\u043f? \u0410 \u0431\u044b\u043b\u0438 \u043b\u0438 \u043e\u0448\u0438\u0431\u043a\u0438? \u0410 \u0437\u043d\u0430\u044e \u043b\u0438 \u044f \u043e \u043d\u0438\u0445<\/p>\n

\u041f\u043e-\u043c\u043e\u0435\u043c\u0443, \u0441\u0435\u0433\u043e\u0434\u043d\u044f \u0432\u0440\u044f\u0434 \u043b\u0438 \u043c\u043e\u0436\u043d\u043e \u043d\u0430\u0439\u0442\u0438 \u0442\u043e\u0433\u043e, \u043a\u0442\u043e \u043d\u0435 \u0434\u0435\u043b\u0430\u0435\u0442 \u0431\u0435\u043a\u0430\u043f. \u041d\u043e \u0432\u043e\u0442 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0442\u044c \u043d\u0430\u043b\u0438\u0447\u0438\u0435 \u043e\u0448\u0438\u0431\u043e\u043a \u043f\u0440\u0438 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0438 \u0431\u0435\u043a\u0430\u043f\u0430, \u043f\u043e\u0436\u0430\u043b\u0443\u0439, \u043f\u043e\u043f\u0440\u043e\u0431\u0443\u044e \u0440\u0430\u0441\u0441\u043a\u0430\u0437\u0430\u0442\u044c \u0432\u0430\u043c \u043a\u0430\u043a \u044d\u0442\u043e \u0434\u0435\u043b\u0430\u0435\u043c \u043c\u044b<\/a>.<\/p>\n

\u0421\u0440\u0430\u0437\u0443 \u043e\u0433\u043e\u0432\u043e\u0440\u044e\u0441\u044c, \u0447\u0442\u043e, \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e, \u0432 \u043f\u0440\u0438\u043d\u0446\u0438\u043f\u0435 \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u044b \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u044b\u0435 \u0441\u0445\u0435\u043c\u044b, \u043d\u043e, \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e, \u0432\u044b \u043d\u0430\u0439\u0434\u0435\u0442\u0435 \u0434\u043b\u044f \u0441\u0435\u0431\u044f, \u0447\u0442\u043e-\u0442\u043e \u043d\u043e\u0432\u043e\u0435, \u0447\u0442\u043e \u0441\u043c\u043e\u0436\u0435\u0442\u0435 \u0432\u043d\u0435\u0434\u0440\u0438\u0442\u044c \u0443 \u0441\u0435\u0431\u044f.<\/p>\n

<\/a><\/p>\n

\u041e\u043f\u0438\u0448\u0435\u043c \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0435 \u0438 \u043f\u0443\u0442\u0438<\/p>\n

PATH=\/usr\/local\/bin:\/usr\/bin:\/bin:\/usr\/local\/mysql\/bin  DATE=`date +%Y-%m-%d_%Hh%Mm`                            # Datestamp e.g 2002-09-21  DOW=`date +%A`                                                  # Day of the week e.g. Monday  DNOW=`date +%u`                                         # Day number of the week 1 to 7 where 1 represents Monday  DOM=`date +%d`                                                  # Date of the Month e.g. 27  M=`date +%B`                                                    # Month e.g January  W=`date +%V`                                                    # Week Number e.g 37  VER=2.5                                                                 # Version Number  LOGFILE=$BACKUPDIR\/$DBHOST-`date +%N`.log               # Logfile Name  LOGERR=$BACKUPDIR\/ERRORS_$DBHOST-`date +%N`.log         # Logfile Name  BACKUPFILES=""  OPT="--quote-names --opt --routines --single-transaction --events"      # OPT string for use with mysqldump ( see man mysqldump )  DBEXCLUDE+=" information_schema performance_schema"     LOCATION="$(cd -P -- "$(dirname -- "$0")" && pwd -P)\/.."  <\/code><\/pre>\n
  \u0414\u043b\u044f \u0432\u0441\u0435\u0445 \u0441\u0435\u0440\u0432\u0435\u0440\u043e\u0432 \u0441\u043a\u0440\u0438\u043f\u0442 \u043e\u0434\u0438\u043d, \u043d\u043e \u043a\u0443\u0434\u0430 \u0436\u0435 \u0431\u0435\u0437 \u0444\u0430\u0439\u043b\u0430 \u043d\u0430\u0441\u0442\u0440\u043e\u0435\u043a. \u0417\u0430\u0447\u0430\u0441\u0442\u0443\u044e \u0435\u0441\u0442\u044c \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0441\u0442\u044c \u043d\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u0432 \u0433\u043b\u043e\u0431\u0430\u043b\u044c\u043d\u044b\u0445 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430\u0445, \u043d\u043e \u0438 \u0432 \u0441\u043f\u0435\u0446\u0438\u0444\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u0434\u043b\u044f \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u0433\u043e \u043f\u0440\u043e\u0435\u043a\u0442\u0430. \u041c\u044b \u0440\u0435\u0448\u0438\u043b\u0438 \u044d\u0442\u043e \u0440\u0430\u0437\u043d\u0435\u0441\u0442\u0438 \u043d\u0430 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0444\u0430\u0439\u043b\u043e\u0432.<\/p>\n
  mysql-backup.conf.dist \u2014 \u0444\u0430\u0439\u043b \u0445\u0440\u0430\u043d\u0438\u0442 \u0433\u043b\u043e\u0431\u0430\u043b\u044c\u043d\u044b\u0435 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438, \u043e\u0431\u0449\u0438\u0435 \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u0432<\/p>\n
  mysql-backup.conf \u2013 \u0444\u0430\u0439\u043b \u0434\u043b\u044f \u0441\u043f\u0435\u0446\u0438\u0444\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u043d\u0430\u0441\u0442\u0440\u043e\u0435\u043a \u0434\u043b\u044f \u043f\u0440\u043e\u0435\u043a\u0442\u0430<\/p>\n
  mysql-backup.local.conf \u2013 \u0444\u0430\u0439\u043b \u0434\u043b\u044f \u043d\u0430\u0441\u0442\u0440\u043e\u0435\u043a \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u043e\u0433\u043e \u0431\u0435\u043a\u0430\u043f\u0430<\/p>\n
  \u041f\u0440\u043e\u0432\u0435\u0440\u0438\u043c, \u0435\u0441\u043b\u0438 \u0435\u0441\u0442\u044c \u043a\u043e\u043d\u0444\u0438\u0433 \u2014 \u0431\u0443\u0434\u0435\u043c \u0434\u0435\u043b\u0430\u0442\u044c \u0431\u0435\u043a\u0430\u043f \u043d\u0430 \u044d\u0442\u043e\u043c \u0441\u0435\u0440\u0432\u0435\u0440\u0435, \u0438 \u043f\u0440\u043e\u0447\u0438\u0442\u0430\u0435\u043c \u043d\u0430\u0448\u0438 \u043a\u043e\u043d\u0444\u0438\u0433\u0438:<\/p>\n
if [ -f "$LOCATION\/etc\/mysql-backup.conf.dist" ]; then      . "$LOCATION\/etc\/mysql-backup.conf.dist"      if [ -f "$LOCATION\/etc\/mysql-backup.conf" ]; then          . "$LOCATION\/etc\/mysql-backup.conf"      fi      if [ -f "$LOCATION\/etc\/mysql-backup.local.conf" ]; then          . "$LOCATION\/etc\/mysql-backup.local.conf"      fi  else      echo "mysql-backup.conf.dist not found"      exit 0  fi <\/code><\/pre>\n
  \u0414\u0430\u043b\u0435\u0435 \u043f\u043e\u0439\u0434\u0451\u043c \u0447\u0438\u0442\u0430\u0442\u044c \u043e\u043f\u0446\u0438\u0438 \u043a\u043e\u043d\u0444\u0438\u0433\u0430 \u0438 \u0443\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0442\u044c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f<\/p>\n
# Add --compress mysqldump option to $OPT  if [ "$COMMCOMP" = "yes" ];          then                  OPT="$OPT --compress"          fi     # Add --compress mysqldump option to $OPT  if [ "$MAX_ALLOWED_PACKET" ];          then                  OPT="$OPT --max_allowed_packet=$MAX_ALLOWED_PACKET"          fi     if [ ! "$BACKUP_DAYS" ];          then                  BACKUP_DAYS=7          fi     if [ ! "$BACKUP_MONTH" ];          then                  BACKUP_MONTH=4          fi     if [ ! "$DO_SQL_DUMP" ];          then                  DO_SQL_DUMP="yes"          fi     if [ ! "$DO_HOT_BACKUP" ];          then                  DO_HOT_BACKUP="no"          fi <\/code><\/pre>\n
  \u0414\u0443\u043c\u0430\u044e \u0442\u0443\u0442 \u043d\u0435 \u043d\u0443\u0436\u043d\u043e \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u043e \u043e\u043f\u0438\u0441\u044b\u0432\u0430\u0442\u044c, \u0442.\u043a. \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u044f \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0445 \u0434\u043e\u043b\u0436\u043d\u044b \u0441\u0430\u043c\u0438 \u0432\u0441\u0451 \u0433\u043e\u0432\u043e\u0440\u0438\u0442\u044c \u0437\u0430 \u0441\u0435\u0431\u044f.<\/p>\n
  \u041f\u0440\u043e\u0432\u0435\u0440\u0438\u043c \u0438 \u0441\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u0434\u0438\u0440\u0435\u043a\u0442\u043e\u0440\u0438\u0438 \u0434\u043b\u044f \u043d\u0430\u0448\u0438\u0445 \u0431\u0435\u043a\u0430\u043f\u043e\u0432<\/p>\n
# Create required directories  if [ ! -e "\/var\/lib\/mysql.backup" ]             # Check Backup Directory exists.          then              mkdir -p "\/var\/lib\/mysql.backup"  fi     if [ ! -e "$BACKUPDIR" ]                # Check Backup Directory exists.          then          mkdir -p "$BACKUPDIR"  fi     if [ ! -e "$BACKUPDIR\/daily" ]          # Check Daily Directory exists.          then          mkdir -p "$BACKUPDIR\/daily"  fi     if [ ! -e "$BACKUPDIR\/weekly" ]         # Check Weekly Directory exists.          then          mkdir -p "$BACKUPDIR\/weekly"  fi     if [ ! -e "$BACKUPDIR\/monthly" ]        # Check Monthly Directory exists.          then          mkdir -p "$BACKUPDIR\/monthly"  fi     if [ "$LATEST" = "yes" ]  then          if [ ! -e "$BACKUPDIR\/latest" ] # Check Latest Directory exists.          then                  mkdir -p "$BACKUPDIR\/latest"          fi  eval rm -fv "$BACKUPDIR\/latest\/*"  fi <\/code><\/pre>\n
  \u041e\u0434\u0438\u043d \u0438\u0437 \u0432\u0430\u0436\u043d\u044b\u0445 \u043c\u043e\u043c\u0435\u043d\u0442\u043e\u0432, \u043d\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u0431\u0435\u043a\u0430\u043f, \u043d\u043e \u0438 \u043f\u0440\u043e\u0432\u0435\u0440\u0438\u0442\u044c \u043e\u0448\u0438\u0431\u043a\u0438 \u0432 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0435 \u0435\u0433\u043e \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f.<\/p>\n
# IO redirection for logging.  touch $LOGFILE  exec 6>&1           # Link file descriptor #6 with stdout.                      # Saves stdout.  exec > $LOGFILE     # stdout replaced with file $LOGFILE.  touch $LOGERR  exec 7>&2           # Link file descriptor #7 with stderr.                      # Saves stderr.  exec 2> $LOGERR     # stderr replaced with file $LOGERR.     echo $LOCATION <\/code><\/pre>\n
  \u041e\u043f\u0438\u0448\u0435\u043c \u043d\u0430\u0448\u0438 \u0444\u0443\u043a\u0446\u0438\u0438. \u0422.\u043a. \u0434\u043b\u044f \u0440\u0430\u0437\u043d\u044b\u0445 \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u0432 \u043d\u0443\u0436\u0435\u043d \u0440\u0430\u0437\u043d\u044b\u0439 \u0431\u0435\u043a\u0430\u043f, \u043a\u043e\u043c\u0443 \u0438\u043d\u043a\u0440\u0435\u043c\u0435\u0442\u043d\u044b\u0439, \u0443 \u043a\u043e\u0433\u043e \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0438 \u043d\u043e\u0447\u044c\u044e \u0441\u043f\u044f\u0442 \u2014 \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u0434\u0430\u043c\u043f\u0430 \u043d\u043e\u0447\u043d\u043e\u0433\u043e.<\/p>\n
  \u041e\u0431\u044b\u0447\u043d\u044b\u0439 mysqldump<\/p>\n
# Database dump function  dbdump () {      if [ "$SEPTABLE" = "yes" ]; then          TABLENAMES="`mysql --user=$USERNAME --password=$PASSWORD --host=$DBHOST --batch --skip-column-names -e "show tables" $1| sed 's\/ \/%\/g'`"          for TABLENAME in $TABLENAMES ; do             OUTFILENAME=`echo $2 | sed "s~$3~$3.$TABLENAME~"`             mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST $OPT $1 $TABLENAME > $OUTFILENAME          done          mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST $OPT --no-data $1 > $2      else          mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST $OPT $1 > $2      fi      return 0  } <\/code><\/pre>\n
  \u0421 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c mydumper<\/p>\n
# Database dump function  dbdump_mydumper () {      MYOPT=""          # Add --ignore-table options to $MYOPT             if [ -n "$TABLEEXCLUDE" ]; then              for table in $TABLEEXCLUDE ; do                  MYOPT="${MYOPT}${table}|"              done          fi          if [ -n "$DBEXCLUDE" ]; then              for table in $DBEXCLUDE ; do                  MYOPT="${MYOPT}${table}|"              done          fi          if [ -n "$MYOPT" ]; then              MYOPT="--regex '^(?!(${MYOPT}mysql.noptable))'"          fi         eval mydumper --user $USERNAME --password $PASSWORD -c -l 300 --kill-long-queries -s 500000 $MYOPT -o $1         if [ $? -gt 0 ]; then            echo "Error in mydumper backup stage" >&2            mysql -u root -p`cat \/root\/.mysql` -e "SHOW FULL PROCESSLIST" | sort -n -k 6 >&2      fi         \/usr\/bin\/find "$BACKUPDIR\/daily" -name "_mydumper*" -type d -mtime +$BACKUP_DAYS -print0 | xargs -0 rm -rf      \/usr\/bin\/find "$BACKUPDIR\/weekly" -name "_mydumper*" -type d -mtime +35 -print0 | xargs -0 rm -rf      \/usr\/bin\/find "$BACKUPDIR\/monthly" -name "_mydumper*" -type d -mtime +100 -print0 | xargs -0 rm -rf      return 0  } <\/code><\/pre>\n
  \u041e\u0431\u044b\u0447\u043d\u043e\u0435 \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445, \u0435\u0441\u0442\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e c \u0431\u043b\u043e\u043a\u0438\u0440\u043e\u0432\u043a\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446<\/p>\n
dbdump_h () {      echo First rsync started at `date`      rsync -avH --delete --numeric-ids \/var\/lib\/mysql\/ \/var\/lib\/mysql.backup      echo First rsync finished at `date`      echo DB locked, second rsync started at `date`      echo "FLUSH TABLES WITH READ LOCK" | mysql --user=$USERNAME --password=$PASSWORD --host=$DBHOST      rsync -avH --delete --numeric-ids \/var\/lib\/mysql\/ \/var\/lib\/mysql.backup      echo "UNLOCK TABLES" | mysql --user=$USERNAME --password=$PASSWORD --host=$DBHOST      echo DB unlocked, second rsync finished at `date`  return 0  } <\/code><\/pre>\n
  \u0418 \u043a\u0443\u0434\u0430 \u0436\u0435 \u0431\u0435\u0437 \u043d\u0435\u0433\u043e, \u0432\u0441\u0435\u043c \u043d\u0430\u043c \u0438\u0437\u0432\u0435\u0441\u0442\u043d\u044b\u0439 \u0438\u043d\u043a\u0440\u0435\u043c\u0435\u043d\u0442\u043d\u044b\u0439 \u0431\u0435\u043a\u0430\u043f<\/p>\n
dbdump_h_xtra () {      if [ ! -f \/usr\/bin\/innobackupex ]; then          yum -y install xtrabackup.x86_64      fi      if [ ! -f \/var\/lib\/mysql-xtra\/xtrabackup_checkpoints ]; then          echo Full backup stage started at `date`          #ionice -c3          \/usr\/bin\/innobackupex --defaults-file=\/etc\/my.cnf --password=`cat \/root\/.mysql` --no-timestamp  --throttle=40 --rsync \/var\/lib\/mysql-xtra 2>&1          if [ $? -gt 0 ]; then            echo "Error in full backup stage" >&2          fi          #ionice -c3          \/usr\/bin\/innobackupex --apply-log --redo-only --defaults-file=\/etc\/my.cnf --password=`cat \/root\/.mysql` --no-timestamp  --throttle=40 \/var\/lib\/mysql-xtra 2>&1          if [ $? -gt 0 ]; then            echo "Error in apply log redo stage" >&2          fi          echo Full backup stage finished at `date` code $?      else          echo INC backup stage started at `date` code $?          rm -rf \/var\/lib\/mysql-xtra-inc          #ionice -c3          \/usr\/bin\/innobackupex --defaults-file=\/etc\/my.cnf --password=`cat \/root\/.mysql` --no-timestamp  --throttle=40  --rsync --incremental \/var\/lib\/mysql-xtra-inc --incremental-basedir=\/var\/lib\/mysql-xtra 2>&1          if [ $? -gt 0 ]; then            echo "Error in inc stage" >&2          fi          #ionice -c3          \/usr\/bin\/innobackupex --defaults-file=\/etc\/my.cnf --password=`cat \/root\/.mysql` --no-timestamp  --throttle=40 --apply-log \/var\/lib\/mysql-xtra --incremental-dir=\/var\/lib\/mysql-xtra-inc 2>&1          if [ $? -gt 0 ]; then            echo "Error in inc apply stage" >&2          fi          \/usr\/bin\/rsync -vaH --delete -f "+ *\/" -f "+ *\/**" -f "- *" \/var\/lib\/mysql-xtra-inc\/ \/var\/lib\/mysql-xtra          rm -rf \/var\/lib\/mysql-xtra-inc          echo INC backup stage finished at `date` code $?      fi  return 0 <\/code><\/pre>\n
  \u041f\u043e\u0436\u0430\u043b\u0443\u0439 \u0438 \u0444\u0443\u043a\u0446\u0438\u044e \u043a\u043e\u043c\u043f\u0440\u0435\u0441\u0438\u0438 \u0432\u044b\u043d\u0435\u0441\u0435\u043c \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e. \u0414\u043b\u044f \u0447\u0435\u0433\u043e? \u2014 \u0424\u0435\u043d\u0448\u0443\u0439. \u041d\u0435\u0438\u0437\u0432\u0435\u0441\u0442\u043d\u043e \u043d\u0430\u0441\u0442\u0440\u043e\u0435\u043d\u0438\u0435 \u043a\u043b\u0438\u0435\u043d\u0442\u0430, \u0438 \u043a\u0430\u043a\u0443\u044e \u043e\u043d \u0437\u0430\u0445\u043e\u0447\u0435\u0442 \u043a\u043e\u043c\u043f\u0440\u0435\u0441\u0441\u0438\u044e. \u0414\u0430\u0434\u0438\u043c \u0435\u043c\u0443 \u043f\u0440\u0430\u0432\u043e \u0432\u044b\u0431\u0440\u0430\u0442\u044c \u0436\u0435\u043b\u0430\u0435\u043c\u044b\u0439 \u0442\u0438\u043f.<\/p>\n
# Compression function plus latest copy  SUFFIX=""  compression () {      if [ "$SEPTABLE" = "yes" ]; then          TBDIR=`\/usr\/bin\/dirname $2`          TFNAME=`\/bin\/basename $2`          if [ "$COMP" = "gzip" ]; then              TPWD=`pwd`              cd $TBDIR              tar -czvf "$1.tgz" ${TFNAME}*.sql 2>&1              cd $TPWD              SUFFIX=".tgz"          elif [ "$COMP" = "bzip2" ]; then              TPWD=`pwd`              cd $TBDIR              tar -cjvf "$1.tbz2" ${TFNAME}*.sql 2>&1              cd $TPWD              SUFFIX=".tbz2"          fi          rm -f ${2}*.sql      else          if [ "$COMP" = "gzip" ]; then              gzip -f "$1"              echo              echo Backup Information for "$1"              gzip -l "$1.gz"              SUFFIX=".gz"          elif [ "$COMP" = "bzip2" ]; then          echo Compression information for "$1.bz2"          bzip2 -f -v $1 2>&1          SUFFIX=".bz2"      else          echo "No compression option set, check advanced settings"      fi fi      if [ "$LATEST" = "yes" ]; then          cp $1$SUFFIX "$BACKUPDIR\/latest\/"      fi      return 0  }  # Compression function plus latest copy  SUFFIX=""  compression_h () {      if [ "$COMP" = "gzip" ]; then          TPWD=`pwd`          cd \/var\/lib\/mysql.backup          tar -czvf "$1.tgz" . 2>&1          cd $TPWD          SUFFIX=".tgz"      elif [ "$COMP" = "bzip2" ]; then          TPWD=`pwd`          cd \/var\/lib\/mysql.backup          tar -cjvf "$1.tbz2" . 2>&1          cd $TPWD          SUFFIX=".tbz2"      else          echo "No compression option set, check advanced settings"      fi      if [ "$LATEST" = "yes" ]; then          cp $1$SUFFIX_H "$BACKUPDIR\/latest\/"      fi      return 0  } <\/code><\/pre>\n
  \u041e\u043f\u0438\u0448\u0435\u043c \u0440\u043e\u0442\u0430\u0446\u0438\u044e. \u041e\u043f\u044f\u0442\u044c \u0436\u0435 \u043f\u043e\u0442\u0440\u0435\u0431\u043d\u043e\u0441\u0442\u0438 \u0432 \u0441\u0440\u043e\u043a\u0435 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0431\u044b\u0432\u0430\u044e\u0442 \u0440\u0430\u0437\u043d\u044b\u0435.<\/p>\n
## rotates monthly backups, set 'keep' to the last n backups to keep  rotateMonthly () {        mdbdir="$1"     ## set to the number of monthly backups to keep  keep=$BACKUP_MONTH     (cd ${mdbdir}         totalFilesCount=`\/bin\/ls -1 | wc -l`         if [ ${totalFilesCount} -gt ${keep} ]; then          purgeFilesCount=`expr ${totalFilesCount} - ${keep}`          purgeFilesList=`\/bin\/ls -1tr | head -${purgeFilesCount}`             echo ""          echo "Rotating monthly: Purging in ${mdbdir}"          rm -fv ${purgeFilesList} | sed -e 's\/^\/\/g'      fi  )  } <\/code><\/pre>\n
  \u0411\u044b\u0432\u0430\u0435\u0442 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u043f\u0435\u0440\u0435\u0434 \u043d\u0430\u0447\u0430\u043b\u043e\u043c \u0437\u0430\u043f\u0443\u0441\u043a\u0430 \u0431\u0435\u043a\u0430\u043f\u0430 \u0432\u044b\u043f\u043e\u043b\u043d\u0438\u0442\u044c \u043a\u043e\u043c\u0430\u043d\u0434\u0443. \u041f\u0440\u0438\u043e\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0441\u0435\u0440\u0432\u0438\u0441, \u043f\u043e\u043a\u0430\u0437\u0430\u0442\u044c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f\u043c \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435 \u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0445. \u0421\u043e\u043e\u0431\u0449\u0438\u0442\u044c \u043f\u043e\u0438\u0441\u043a\u043e\u0432\u0438\u043a\u0430\u043c \u0438 \u0434\u0430\u043c\u043f\u0435 \u043e\u0433\u0440\u043e\u043c\u043d\u043e\u0439 \u0431\u0430\u0437\u044b. \u041f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u0438\u043c \u0442\u0430\u043a\u0443\u044e \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c.<\/p>\n
# Run command before we begin  if [ "$PREBACKUP" ]          then          echo ======================================================================          echo "Prebackup command output."          echo          eval $PREBACKUP          echo          echo ======================================================================          echo  fi <\/code><\/pre>\n
  \u041f\u043e\u0440\u043e\u0439 \u043d\u0435 \u0432\u0441\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u043d\u0443\u0436\u043d\u043e \u0431\u0435\u043a\u0430\u043f\u0438\u0442\u044c.<\/p>\n
# Add --ignore-table options to $OPT  if [ -n "$TABLEEXCLUDE" ]; then          for table in $TABLEEXCLUDE ; do                  OPT="${OPT} --ignore-table=${table}"          done  fi <\/code><\/pre>\n
  \u0414\u0443\u043c\u0430\u044e, \u044d\u0442\u0430 \u0447\u0430\u0441\u0442\u044c \u0432 \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u0438 \u043d\u0435 \u043d\u0443\u0436\u0434\u0430\u0435\u0442\u0441\u044f<\/p>\n
if [ "$SEPDIR" = "yes" ]; then # Check if CREATE DATABSE should be included in Dump          if [ "$CREATE_DATABASE" = "no" ]; then                  OPT="$OPT --no-create-db"          else                  OPT="$OPT --databases"          fi  else          OPT="$OPT --databases"  fi     # Hostname for LOG information  if [ "$DBHOST" = "localhost" ]; then          HOST=`hostname`          if [ "$SOCKET" ]; then                  OPT="$OPT --socket=$SOCKET"          fi  else          HOST=$DBHOST  fi <\/code><\/pre>\n
  \u041f\u0440\u043e\u0447\u0438\u0442\u0430\u0435\u043c \u0432\u0441\u0435 \u0431\u0430\u0437\u044b \u0438 \u0443\u0434\u0430\u043b\u0438\u043c \u0438\u0437 \u0441\u043f\u0438\u0441\u043a\u0430 \u0434\u043b\u044f \u0431\u0435\u043a\u0430\u043f\u0430 \u0431\u0430\u0437\u044b \u0438\u0441\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f<\/p>\n
# If backing up all DBs on the server  if [ "$DBNAMES" = "all" ]; then          DBNAMES="`mysql --user=$USERNAME --password=$PASSWORD --host=$DBHOST --batch --skip-column-names -e "show databases"| sed 's\/ \/%\/g'`"             # If DBs are excluded          for exclude in $DBEXCLUDE          do                  DBNAMES=`echo $DBNAMES | sed "s\/\\b$exclude\\b\/\/g"`          done             MDBNAMES=$DBNAMES  Fi <\/code><\/pre>\n
  \u041f\u043e\u0440\u0430 \u043f\u0440\u0438\u0441\u0442\u0443\u043f\u0438\u0442\u044c \u0441\u0430\u043c\u043e\u043c\u0443 \u0431\u0435\u043a\u0430\u043f\u0443<\/p>\n
echo ======================================================================  echo AutoMySQLBackup VER $VER  echo http:\/\/sourceforge.net\/projects\/automysqlbackup\/  echo  echo Backup of Database Server - $HOST  echo ====================================================================== <\/code><\/pre>\n
  \u041d\u0430\u043c \u043d\u0443\u0436\u043d\u044b \u0434\u0430\u043c\u043f\u044b? \u041f\u0440\u0438\u0441\u0442\u0443\u043f\u0438\u043c \u043a \u0434\u0430\u043c\u043f\u0430\u043c<\/p>\n
if [ "$DO_SQL_DUMP" = "yes" ]; then     echo Backup Start Time `date`  echo ====================================================================== <\/code><\/pre>\n
  \u0422\u0430\u043a\u0436\u0435 \u043f\u043e \u0444\u0435\u043d\u0448\u0443\u044e \u0443\u0434\u043e\u0431\u043d\u043e \u0440\u0430\u0437\u0434\u0435\u043b\u044f\u0442\u044c \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0435 \u0442\u0438\u043f\u044b \u0431\u0435\u043a\u0430\u043f\u0430, \u043d\u0443 \u0447\u0442\u043e \u0436 \u0441\u0435\u0433\u043e\u0434\u043d\u044f \u043f\u0435\u0440\u0432\u043e\u0435 \u0447\u0438\u0441\u043b\u043e? \u0421\u0434\u0435\u043b\u0430\u0435\u043c \u043c\u0435\u0441\u044f\u0447\u043d\u044b\u0439 \u0434\u0430\u043c\u043f.<\/p>\n
 # Monthly Full Backup of all Databases          if [ $DOM = "01" ]; then                  for MDB in $MDBNAMES                  do                           # Prepare $DB for using                          MDB="`echo $MDB | sed 's\/%\/ \/g'`"                             if [ ! -e "$BACKUPDIR\/monthly\/$MDB" ]           # Check Monthly DB Directory exists.                          then                                  mkdir -p "$BACKUPDIR\/monthly\/$MDB"                          fi                          echo Monthly Backup of $MDB...                                  dbdump "$MDB" "$BACKUPDIR\/monthly\/$MDB\/${MDB}_$DATE.$M.$MDB.sql" "$BACKUPDIR\/monthly\/$MDB\/${MDB}"                                  compression "$BACKUPDIR\/monthly\/$MDB\/${MDB}_$DATE.$M.$MDB.sql" "$BACKUPDIR\/monthly\/$MDB\/${MDB}"                                  BACKUPFILES="$BACKUPFILES $BACKUPDIR\/monthly\/$MDB\/${MDB}_$DATE.$M.$MDB.sql$SUFFIX"                          echo ----------------------------------------------------------------------                          TTT=`expr 33 \\* $BACKUP_MONTH`                          \/usr\/bin\/find "$BACKUPDIR\/monthly\/$MDB" -name "*.sql.*" -mtime +$TTT -type f -delete                     done <\/code><\/pre>\n
  \u041d\u0435 \u043f\u0435\u0440\u0432\u043e\u0435 \u0447\u0438\u0441\u043b\u043e \u043c\u0435\u0441\u044f\u0446\u0430? \u2013 \u043f\u0440\u0438\u0441\u0442\u0443\u043f\u0430\u0435\u043c \u043a \u043f\u043e\u0432\u0441\u0435\u0434\u043d\u0435\u0432\u043d\u043e-\u0435\u0436\u0435\u0434\u043d\u0435\u0432\u043d\u043e\u043c\u0443 \u0431\u0435\u043a\u0430\u043f\u0443. \u041f\u0440\u0435\u043f\u043e\u043b\u0430\u0433\u0430\u044e, \u0447\u0442\u043e \u043f\u043e\u0441\u0442\u0440\u043e\u0447\u043d\u043e\u0435 \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u0435 \u043d\u0435 \u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f.<\/p>\n
else                     for DB in $DBNAMES                  do                  # Prepare $DB for using                  DB="`echo $DB | sed 's\/%\/ \/g'`"                     # Create Seperate directory for each DB                  if [ ! -e "$BACKUPDIR\/daily\/$DB" ]              # Check Daily DB Directory exists.                  then                          mkdir -p "$BACKUPDIR\/daily\/$DB"                  fi                  if [ $BACKUP_DAYS -le 7 ]; then                      if [ ! -e "$BACKUPDIR\/weekly\/$DB" ]         # Check Weekly DB Directory exists.                      then                          mkdir -p "$BACKUPDIR\/weekly\/$DB"                      fi                      # Weekly Backup                  fi                  if [ $DNOW = $DOWEEKLY -a $BACKUP_DAYS -le 7 ]; then                      echo Weekly Backup of Database \\( $DB \\)                      echo Rotating 5 weeks Backups...                      if [ "$W" -le 05 ];then                                  REMW=`expr 48 + $W`                          elif [ "$W" -lt 15 ];then                                  REMW=0`expr $W - 5`                          else                                  REMW=`expr $W - 5`                      fi                      eval rm -fv "$BACKUPDIR\/weekly\/$DB\/${DB}_week.$REMW.*"   echo                          dbdump "$DB" "$BACKUPDIR\/weekly\/$DB\/${DB}_week.$W.$DATE.sql" "$BACKUPDIR\/weekly\/$DB\/${DB}"                          compression "$BACKUPDIR\/weekly\/$DB\/${DB}_week.$W.$DATE.sql" "$BACKUPDIR\/weekly\/$DB\/${DB}"                          BACKUPFILES="$BACKUPFILES $BACKUPDIR\/weekly\/$DB\/${DB}_week.$W.$DATE.sql$SUFFIX"                      echo ----------------------------------------------------------------------                  # Daily Backup                  else                      echo Daily Backup of Database \\( $DB \\)                      echo Rotating last weeks Backup...                      \/usr\/bin\/find "$BACKUPDIR\/daily\/$DB" -name "*.sql.*" -mtime +$BACKUP_DAYS -delete                      echo                          dbdump "$DB" "$BACKUPDIR\/daily\/$DB\/${DB}_$DATE.$DOW.sql" "$BACKUPDIR\/daily\/$DB\/${DB}"                          compression "$BACKUPDIR\/daily\/$DB\/${DB}_$DATE.$DOW.sql" "$BACKUPDIR\/daily\/$DB\/${DB}"                          BACKUPFILES="$BACKUPFILES $BACKUPDIR\/daily\/$DB\/${DB}_$DATE.$DOW.sql$SUFFIX"                      echo ----------------------------------------------------------------------                  fi                  done          fi  echo Backup End `date`  echo ======================================================================  fi <\/code><\/pre>\n
  \u041d\u0430\u043c \u043d\u0443\u0436\u0435\u043d HOT BACKUP? \u041f\u0440\u0438\u0441\u0442\u0443\u043f\u0438\u043c:<\/p>\n
#### HOT BACKUP  if [ "$DO_HOT_BACKUP" = "yes" ]; then         echo HOT Backup Start `date`      echo ======================================================================      # Monthly HOT Full Backup of all Databases      if [ $DOM = "01" ]; then          echo Monthly full Backup of \\( $MDBNAMES \\)...          dbdump_h "$MDBNAMES" "$BACKUPDIR\/monthly\/$DATE.$M.all-databases.sql"  ###        compression_h "$BACKUPDIR\/monthly\/$DATE.$M.all-databases.sql"          BACKUPFILES="$BACKUPFILES $BACKUPDIR\/monthly\/$DATE.$M.all-databases.sql$SUFFIX"          echo ----------------------------------------------------------------------  ###     TTT=`expr 33 \\* $BACKUP_MONTH`  ###     \/usr\/bin\/find "$BACKUPDIR\/monthly\/" -name "*.all-databases.sql.*" -mtime +$TTT -type f -delete      else  # Weekly Backup      if [ $DNOW = $DOWEEKLY -a $BACKUP_DAYS -le 7 ]; then          echo Weekly Backup of Databases \\( $DBNAMES \\)          echo          echo Rotating 5 weeks Backups...          if [ "$W" -le 05 ];then                  REMW=`expr 48 + $W`          elif [ "$W" -lt 15 ];then                  REMW=0`expr $W - 5`          else                  REMW=`expr $W - 5`          fi          eval rm -fv "$BACKUPDIR\/weekly\/week.$REMW.*"          echo          dbdump_h "$DBNAMES" "$BACKUPDIR\/weekly\/week.$W.$DATE.sql"  ###        compression_h "$BACKUPDIR\/weekly\/week.$W.$DATE.sql"          BACKUPFILES="$BACKUPFILES $BACKUPDIR\/weekly\/week.$W.$DATE.sql$SUFFIX"          echo ----------------------------------------------------------------------  # Daily Backup else          echo Daily Backup of Databases \\( $DBNAMES \\)          echo          echo Rotating last weeks Backup...          \/usr\/bin\/find "$BACKUPDIR\/daily\/$DB" -name "*.sql.*" -mtime +$BACKUP_DAYS -delete          echo          dbdump_h "$DBNAMES" "$BACKUPDIR\/daily\/$DATE.$DOW.sql"  ###        compression_h "$BACKUPDIR\/daily\/$DATE.$DOW.sql"          BACKUPFILES="$BACKUPFILES $BACKUPDIR\/daily\/$DATE.$DOW.sql$SUFFIX"          echo ----------------------------------------------------------------------      fi      fi      echo Backup End Time `date`      echo ======================================================================  fi <\/code><\/pre>\n
  HOT XTRA BACKUP? \u2014 \u0441\u0434\u0435\u043b\u0430\u0435\u043c \u0435\u0433\u043e:<\/p>\n
#### HOT XTRA BACKUP  if [ "$HOT_XTRA_BACKUP" = "yes" ]; then      dbdump_h_xtra  fi     \u0418 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0439 \u0432\u0430\u0440\u0438\u0430\u043d\u0442 - mydumper:  #### DO_MYDUMPER_BACKUP  if [ "$DO_MYDUMPER_BACKUP" = "yes" ]; then      # Monthly Full Backup of all Databases      BACKUPDIRM=$BACKUPDIR\/daily\/      if [ $DOM = "01" ]; then         BACKUPDIRM=$BACKUPDIR\/monthly\/      else        if [ $DNOW = $DOWEEKLY -a $BACKUP_DAYS -le 7 ]; then          BACKUPDIRM=$BACKUPDIR\/weekly\/        fi      fi      BACKUPDIRM=${BACKUPDIRM}_mydumper-`date +%F_%R`      dbdump_mydumper "$BACKUPDIRM"      OPT="$OPT --no-data"      for DB in $DBNAMES      do          # Prepare $DB for using          DB="`echo $DB | sed 's\/%\/ \/g'`"          dbdump "$DB" "$BACKUPDIRM\/$DB-schema.sql"          compression "$BACKUPDIRM\/$DB-schema.sql"      done  fi <\/code><\/pre>\n
  \u041f\u043e\u0441\u0447\u0438\u0442\u0430\u0435\u043c \u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0437\u0430\u043d\u0438\u043c\u0430\u044e\u0442 \u0434\u0430\u043c\u043f\u044b, \u043c\u0435\u0441\u0442\u043e \u0438\u043c\u0435\u0435\u0442 \u043f\u0440\u0438\u0432\u044b\u0447\u043a\u0443 \u0437\u0430\u043a\u0430\u043d\u0447\u0438\u0432\u0430\u0442\u044c\u0441\u044f.<\/p>\n
echo Total disk space used for backup storage..  echo Size - Location  echo `du -hs "$BACKUPDIR"`  echo <\/code><\/pre>\n
  \u041f\u043e\u0440\u043e\u0439 \u0431\u044b\u0432\u0430\u0435\u0442 \u043d\u0443\u0436\u043d\u043e \u0432\u044b\u043f\u043e\u043b\u043d\u0438\u0442\u044c \u043a\u043e\u043c\u0430\u043d\u0434\u0443, \u043f\u043e\u0441\u043b\u0435 \u0431\u0435\u043a\u0430\u043f\u0430, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 \u0432\u043d\u043e\u0432\u044c \u043e\u0442\u043a\u0440\u044b\u0442\u044c \u0441\u0430\u0439\u0442. \u041f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u0438\u043c \u0442\u0430\u043a\u0443\u044e \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c:<\/p>\n
# Run command when we're done  if [ "$POSTBACKUP" ]          then          echo ======================================================================          echo "Postbackup command output."          echo          eval $POSTBACKUP          echo          echo ======================================================================  fi <\/code><\/pre>\n
  \u041f\u0440\u0438\u0441\u0442\u0443\u043f\u0438\u043c \u043a \u0430\u043d\u0430\u043b\u0438\u0437\u0443 \u043b\u043e\u0433\u0430 \u0431\u0435\u043a\u0430\u043f\u0430<\/p>\n
#Clean up IO redirection  exec 1>&6 6>&-      # Restore stdout and close file descriptor #6.  exec 1>&7 7>&-      # Restore stdout and close file descriptor #7. <\/code><\/pre>\n
  \u0414\u0430, \u043c\u044b \u0437\u043d\u0430\u0435\u043c, \u0441\u043f\u0430\u0441\u0438\u0431\u043e. \u0423\u0434\u0430\u043b\u0438\u043c \u044d\u0442\u043e \u0438\u0437 \u043d\u0430\u0448\u0435\u0433\u043e \u043b\u043e\u0433\u0430.<\/p>\n
sed -i '\/Using a password on the command line interface can be insecure\/d' $LOGERR <\/code><\/pre>\n
  \u0414\u0430\u043b\u0435\u0435 \u0443 \u043d\u0430\u0441 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0432\u0430\u0440\u0438\u0430\u043d\u0442\u043e\u0432: \u043f\u0440\u0438\u0441\u043b\u0430\u0442\u044c \u043b\u043e\u0433 \u0440\u0430\u0431\u043e\u0442\u044b \u0441\u043a\u0440\u0438\u043f\u0442\u0430, \u043f\u0440\u0438\u0441\u043b\u0430\u0442\u044c \u043b\u043e\u0433 \u0438 \u0444\u0430\u0439\u043b\u044b \u0434\u0430\u043c\u043f\u0430, \u043f\u043e\u043a\u0430\u0437\u0430\u0442\u044c \u0432\u044b\u0432\u043e\u0434 \u0432 \u043a\u043e\u043d\u0441\u043e\u043b\u044c (\u043e\u0442\u043b\u0430\u0434\u043a\u0430, \u043a\u0443\u0434\u0430 \u0436\u0435 \u0431\u0435\u0437 \u043d\u0435\u0451), \u043f\u0440\u0438\u0441\u043b\u0430\u0442\u044c \u043d\u0430 \u043f\u043e\u0447\u0442\u0443 \u043b\u043e\u0433 \u0438 \u0435\u0441\u043b\u0438 \u0435\u0441\u0442\u044c \u043e\u0448\u0438\u0431\u043a\u0438.<\/p>\n
  \u041f\u043e\u0436\u0430\u043b\u0443\u0439 \u0432 \u0434\u0435\u0444\u043e\u043b\u0442\u0435 \u043c\u044b \u0432\u044b\u0431\u0438\u0440\u0430\u0435\u043c \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0439 \u0432\u0430\u0440\u0438\u0430\u043d\u0442. \u041d\u043e \u043e\u043f\u0438\u0448\u0435\u043c \u0432\u0441\u0435.<\/p>\n
if [ "$MAILCONTENT" = "files" ]  then          if [ -s "$LOGERR" ]          then                  # Include error log if is larger than zero.                  BACKUPFILES="$BACKUPFILES $LOGERR"                  ERRORNOTE="WARNING: Error Reported - "          fi          #Get backup size          ATTSIZE=`du -c $BACKUPFILES | grep "[[:digit:][:space:]]total$" |sed s\/\\s*total\/\/`          if [ $MAXATTSIZE -ge $ATTSIZE ]          then                  BACKUPFILES=`echo "$BACKUPFILES" | sed -e "s# # -a #g"` #enable multiple attachments                  mutt -s "$ERRORNOTE MySQL Backup Log and SQL Files for $HOST - $DATE" $BACKUPFILES $MAILADDR < $LOGFILE         #send via mutt          else                  cat "$LOGFILE" | mail -s "WARNING! - MySQL Backup exceeds set maximum attachment size on $HOST - $DATE" $MAILADDR          fi  elif [ "$MAILCONTENT" = "log" ]  then          cat "$LOGFILE" | mail -s "MySQL Backup Log for $HOST - $DATE" $MAILADDR          if [ -s "$LOGERR" ]                  then                          cat "$LOGERR" | mail -s "ERRORS REPORTED: MySQL Backup error Log for $HOST - $DATE" $MAILADDR          fi  elif [ "$MAILCONTENT" = "quiet" ]  then          if [ -s "$LOGERR" ]                  then                          cat "$LOGERR" | mail -s "ERRORS REPORTED: MySQL Backup error Log for $HOST - $DATE" $MAILADDR                          cat "$LOGFILE" | mail -s "MySQL Backup Log for $HOST - $DATE" $MAILADDR          fi  else          if [ -s "$LOGERR" ]                  then                          cat "$LOGFILE"                         echo                          echo "###### WARNING ######"                          echo "Errors reported during AutoMySQLBackup execution.. Backup failed"                          echo "Error log below.."                          cat "$LOGERR"          else                  cat "$LOGFILE"          fi  fi <\/code><\/pre>\n
  \u041f\u043e\u0447\u0438\u0441\u0442\u0438\u043c \u0437\u0430 \u0441\u043e\u0431\u043e\u0439:<\/p>\n
if [ -s "$LOGERR" ]          then                  STATUS=1          else                  STATUS=0  fi     # Clean up Logfile  eval rm -f "$LOGFILE"  eval rm -f "$LOGERR"  exit $STATUS <\/code><\/pre>\n
  \u0422\u0435\u043f\u0435\u0440\u044c \u043f\u0440\u0438\u0432\u0435\u0434\u0443 \u0444\u0430\u0439\u043b \u043a\u043e\u043d\u0444\u0438\u0433 \u0434\u043b\u044f \u043e\u043f\u0446\u0438\u0439:<\/p>\n
# Username to access the MySQL server e.g. dbuser  USERNAME=root     # Username to access the MySQL server e.g. password  if [ -f "\/root\/.mysql" ]; then      PASSWORD=`cat \/root\/.mysql`  else      exit 0  fi     # Host name (or IP address) of MySQL server e.g localhost  DBHOST=localhost     # List of DBNAMES for Daily\/Weekly Backup e.g. "DB1 DB2 DB3"  DBNAMES="all"     # Backup directory location e.g \/backups  BACKUPDIR="\/var\/backups\/mysql"     # Mail setup  # What would you like to be mailed to you?  # - log   : send only log file  # - files : send log file and sql files as attachments (see docs)  # - stdout : will simply output the log to the screen if run manually.  # - quiet : Only send logs if an error occurs to the MAILADDR.  MAILCONTENT="quiet"     # Set the maximum allowed email size in k. (4000 = approx 5MB email [see docs])  MAXATTSIZE="4000"     # Email Address to send mail to? (user@domain.com)  MAILADDR="root" # ============================================================  # === ADVANCED OPTIONS ( Read the doc's below for details )===  #=============================================================     # List of DBBNAMES for Monthly Backups.  MDBNAMES="mysql $DBNAMES"     # List of DBNAMES to EXLUCDE if DBNAMES are set to all (must be in " quotes)  DBEXCLUDE="information_schema performance_schema "     # List of tables to exclude from the backup (in form db.table)  TABLEEXCLUDE=""     # Include CREATE DATABASE in backup?  CREATE_DATABASE=no     # Separate backup directory and file for each DB? (yes or no)  SEPDIR=yes     # Which day do you want weekly backups? (1 to 7 where 1 is Monday)  DOWEEKLY=0     # How many days keep backup  BACKUP_DAYS=3     # Choose Compression type. (gzip or bzip2)  COMP=gzip  # Compress communications between backup server and MySQL server?  COMMCOMP=no     # Additionally keep a copy of the most recent backup in a seperate directory.  LATEST=no     #  The maximum size of the buffer for client\/server communication. e.g. 16MB (maximum is 1GB)  MAX_ALLOWED_PACKET=1GB  #  For connections to localhost. Sometimes the Unix socket file must be specified.  OS=`uname`  if [ "$OS" = "FreeBSD" ]; then      SOCKET=\/tmp\/mysql.sock  else      SOCKET=\/var\/lib\/mysql\/mysql.sock  fi     # Command to run before backups (uncomment to use)  #PREBACKUP="\/etc\/mysql-backup-pre"     # Command run after backups (uncomment to use)  #POSTBACKUP="\/etc\/mysql-backup-post"     # (\u0435\u0441\u043b\u0438 \u043d\u0435 \u043e\u043f\u0438\u0441\u0430\u043d\u043e, \u043f\u043e-\u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e \u0442\u0430\u043a \u0438 \u0434\u0435\u043b\u0430\u0442\u044c)  DO_SQL_DUMP=yes  # separate table to file ?  SEPTABLE=no     # (\u0435\u0441\u043b\u0438 \u043d\u0435 \u043e\u043f\u0438\u0441\u0430\u043d\u043e, \u043f\u043e-\u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e \u043d\u0435 \u0434\u0435\u043b\u0430\u0442\u044c)  DO_HOT_BACKUP=no  HOT_XTRA_BACKUP=no  DO_MYDUMPER_BACKUP=no  <\/code><\/pre>\n
  \u041c\u044b \u043d\u0435 \u0441\u0442\u0430\u0432\u0438\u043b\u0438 \u0446\u0435\u043b\u044c\u044e \u00ab\u043e\u0442\u043a\u0440\u044b\u0442\u044c \u0410\u043c\u0435\u0440\u0438\u043a\u0443\u00bb, \u043d\u043e \u0442\u0435\u043c\u0430 \u0431\u0435\u043a\u0430\u043f\u043e\u0432 \u043d\u0435 \u043f\u0435\u0440\u0435\u0441\u0442\u0430\u0451\u0442 \u0431\u044b\u0442\u044c \u0430\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u043e\u0439. \u0418 \u0437\u0430\u0447\u0430\u0441\u0442\u0443\u044e \u0432\u0441\u0442\u0440\u0435\u0447\u0430\u0435\u0442\u0441\u044f \u0442\u0430\u043a, \u0447\u0442\u043e \u0434\u043e\u0431\u0430\u0432\u0438\u0432 \u0441\u0442\u0440\u043e\u043a\u0443 \u0432 \u0441\u043a\u0440\u0438\u043f\u0442 \u0434\u0430\u043c\u043f \u0431\u0430\u0437\u044b, \u0437\u0430\u0431\u044b\u0432\u0430\u0435\u043c \u043f\u0440\u043e\u0432\u0435\u0440\u0438\u0442\u044c \u043d\u0430\u043b\u0438\u0447\u0438\u0435 \u043e\u0448\u0438\u0431\u043e\u043a \u0432 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0435 \u0434\u0430\u043c\u043f\u0430. \u041d\u0430\u0434\u0435\u044e\u0441\u044c \u0432 \u044d\u0442\u0430 \u0441\u0442\u0430\u0442\u044c\u044f \u043d\u0430\u043f\u043e\u043c\u043d\u0438\u0442 \u0432\u0430\u043c \u043e \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0441\u0442\u0438 \u043e\u0447\u0435\u0440\u0435\u0434\u043d\u043e\u0439 \u0440\u0430\u0437 \u043f\u0440\u043e\u0432\u0435\u0440\u0438\u0442\u044c \u043d\u0430\u043b\u0438\u0447\u0438\u0435 \u0431\u0435\u043a\u0430\u043f\u043e\u0432. \u0410 \u0442\u044b \u043f\u0440\u043e\u0432\u0435\u0440\u0438\u043b \u0441\u0432\u043e\u0439 \u0431\u0435\u043a\u0430\u043f?<\/p>\n
  \"image\"\/      \t<\/p>\n
<\/div>\n<\/p><\/div>\n
 \u0441\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b \u0441\u0442\u0430\u0442\u044c\u0438  http:\/\/habrahabr.ru\/company\/centosadmin\/blog\/227533\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
     \t\"image\"\/<\/p>\n
  \u041d\u0435\u0442 \u0441\u043c\u044b\u0441\u043b\u0430 \u0433\u043e\u0432\u043e\u0440\u0438\u0442\u044c \u043e \u0442\u043e\u043c, \u043d\u0430\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u044d\u0442\u043e \u0430\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0432\u043e\u043f\u0440\u043e\u0441. \u0421\u0435\u0433\u043e\u0434\u043d\u044f \u043c\u044b \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0435\u043c, \u043a\u0430\u043a \u0443 \u043d\u0430\u0441 \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u043e\u0432\u0430\u043d\u043e \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0435 \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 mysql. 
  \u0418 \u043e\u0434\u043d\u043e \u0438\u0445 \u0441\u0430\u043c\u044b\u0445 \u0432\u0430\u0436\u043d\u044b\u0445 \u2013 \u044d\u0442\u043e \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0430, \u0430 \u0441\u0434\u0435\u043b\u0430\u043b\u0441\u044f \u043b\u0438 \u0431\u0435\u043a\u0430\u043f? \u0410 \u0443\u0441\u043f\u0435\u0448\u043d\u043e \u043b\u0438 \u043f\u0440\u043e\u0448\u0435\u043b \u0434\u0430\u043c\u043f? \u0410 \u0431\u044b\u043b\u0438 \u043b\u0438 \u043e\u0448\u0438\u0431\u043a\u0438? \u0410 \u0437\u043d\u0430\u044e \u043b\u0438 \u044f \u043e \u043d\u0438\u0445<\/p>\n
  \u041f\u043e-\u043c\u043e\u0435\u043c\u0443, \u0441\u0435\u0433\u043e\u0434\u043d\u044f \u0432\u0440\u044f\u0434 \u043b\u0438 \u043c\u043e\u0436\u043d\u043e \u043d\u0430\u0439\u0442\u0438 \u0442\u043e\u0433\u043e, \u043a\u0442\u043e \u043d\u0435 \u0434\u0435\u043b\u0430\u0435\u0442 \u0431\u0435\u043a\u0430\u043f. \u041d\u043e \u0432\u043e\u0442 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0442\u044c \u043d\u0430\u043b\u0438\u0447\u0438\u0435 \u043e\u0448\u0438\u0431\u043e\u043a \u043f\u0440\u0438 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0438 \u0431\u0435\u043a\u0430\u043f\u0430, \u043f\u043e\u0436\u0430\u043b\u0443\u0439, \u043f\u043e\u043f\u0440\u043e\u0431\u0443\u044e \u0440\u0430\u0441\u0441\u043a\u0430\u0437\u0430\u0442\u044c \u0432\u0430\u043c \u043a\u0430\u043a \u044d\u0442\u043e \u0434\u0435\u043b\u0430\u0435\u043c \u043c\u044b<\/a>.<\/p>\n
  \u0421\u0440\u0430\u0437\u0443 \u043e\u0433\u043e\u0432\u043e\u0440\u044e\u0441\u044c, \u0447\u0442\u043e, \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e, \u0432 \u043f\u0440\u0438\u043d\u0446\u0438\u043f\u0435 \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u044b \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u044b\u0435 \u0441\u0445\u0435\u043c\u044b, \u043d\u043e, \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e, \u0432\u044b \u043d\u0430\u0439\u0434\u0435\u0442\u0435 \u0434\u043b\u044f \u0441\u0435\u0431\u044f, \u0447\u0442\u043e-\u0442\u043e \u043d\u043e\u0432\u043e\u0435, \u0447\u0442\u043e \u0441\u043c\u043e\u0436\u0435\u0442\u0435 \u0432\u043d\u0435\u0434\u0440\u0438\u0442\u044c \u0443 \u0441\u0435\u0431\u044f.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-227533","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/227533","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=227533"}],"version-history":[{"count":0,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/227533\/revisions"}],"wp:attachment":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=227533"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=227533"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=227533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}