ouwsh's blog 畅想生活

#!/bin/bash

PATH=/usr/local/sbin:/usr/bin:/bin

#get cur date str 2008-10-12
DATE=`date -I`

#set backup path info
DATADIR="/var/lib/mysql"
BASE_BAK_DIR="/backup"
CUR_BAK_DIR="$BASE_BAK_DIR/current"

#set mysql user name and password
MYSQL_USER="root"
MYSQL_PWD="rootpwd"
MYACC=" -u'$MYSQL_USER' -p'$MYSQL_PWD' "

#set backup type info
INTERVAL="$1"

# days, files in base_bak_path
# before this days will be deleted
RETENTION=21
#get host name (a part of bin log file names,
#  if change set master bin file manual, need change this)
HOST=`hostname -s`

#set mysql version
MYVERSION="4.1"

if [ "$MYVERSION" = '4.1' ] || [ "$MYVERSION" = '5.0' ] ; then
  #purge master logs to latest backup time (remain one hour bin log for slave replication delay)
  PURGELOGS="mysql $MYACC -e \"PURGE MASTER LOGS BEFORE DATE_SUB( NOW(), INTERVAL 1 HOUR )\""
else    
echo "not support MYSql Ver $MYVERSION"
exit 1
fi
      
#check param input (daily or hourly)
if [ ! $1 ];
then    
  read -p "Backup Interval? (Hourly|Daily) : " INTERVAL
fi    

case $INTERVAL in
  hourly | HOURLY | Hourly | H | h | 1 )
  echo "Performing hourly level backup — `date`"
  MYCMD="mysql $MYACC -e \"FLUSH LOGS\""
  eval $MYCMD

  if [ -d $BASE_BAK_DIR/$DATE ] && [ "$MYVERSION" = '4.1' -o "$MYVERSION" = '5.0' ] ; then
     rsync -aub $DATADIR/$HOST-bin.?????? $BASE_BAK_DIR/$DATE
  else    
     echo "dest dir not exists! please run daily backup first." 1>&2
     exit 1
  fi
  exit 0
  ;;

  daily | DAILY | Daily | D | d | 2 )
  echo "Performing daily level backup — `date`"
  # check dest path
  if [ ! -d $CUR_BAK_DIR ]; then    
     echo "Creating $CUR_BAK_DIR"
     mkdir -p $CUR_BAK_DIR
  fi

  MYCMD="mysqlhotcopy $MYACC –regexp=.* $CUR_BAK_DIR"
  eval $MYCMD
  chown -R mysql: $CUR_BAK_DIR/
  mv $CUR_BAK_DIR $BASE_BAK_DIR/$DATE
  eval $PURGELOGS

  #delete files that outdate
  find $BASE_BAK_DIR -ctime +$RETENTION -exec rm -rf '{}' \;
  exit 0
  ;;
  
  * )
  echo "Invalid Selection" 1>&2
  exit 1

DATADIR="/var/lib/mysql"
BASE_BAK_DIR="/backup"
CUR_BAK_DIR="$BASE_BAK_DIR/current"

#set mysql user name and password
MYSQL_USER=”root”
MYSQL_PWD=”rootpwd”