interface/main/backuplog.sh

   1 #/bin/bash
   2 # $1 - mysql user $2 mysql password   $3 mysql Database $4 Log backup directory
   3
   4 # Create temp tables as that of Eventlog and log_comment_encrypt and log_validator
   5 mysql -u $1 -p$2 -h $5 --port=$6 -D $3 -e "create table if not exists log_comment_encrypt_new like log_comment_encrypt"
   6 mysql -u $1 -p$2 -h $5 --port=$6 -D $3 -e "create table if not exists log_new like log"
   7 mysql -u $1 -p$2 -h $5 --port=$6 -D $3 -e "create table if not exists log_validator_new like log_validator"
   8 # Rename the existing  tables to backup & New tables to Event tables
   9 mysql -u $1 -p$2 -h $5 --port=$6 -D $3 -e "rename table log_comment_encrypt to log_comment_encrypt_backup,log_comment_encrypt_new to log_comment_encrypt"
  10 mysql -u $1 -p$2 -h $5 --port=$6 -D $3 -e "rename table log to log_backup,log_new to log"
  11 mysql -u $1 -p$2 -h $5 --port=$6 -D $3 -e "rename table log_validator to log_validator_backup,log_validator_new to log_validator"
  12 # Dump the Backup tables
  13 mysqldump -u $1 -p$2 -h $5 --port=$6 --opt --quote-names -r $4 $3 --tables log_comment_encrypt_backup log_backup log_validator_backup
  14 if [ $? -eq 0 ]
  15 then
  16 # After Successful dumping, drop the Backup tables
  17 mysql -u $1 -p$2 -h $5 --port=$6 -D $3 -e "drop table if exists log_comment_encrypt_backup"
  18 mysql -u $1 -p$2 -h $5 --port=$6 -D $3 -e "drop table if exists log_backup"
  19 mysql -u $1 -p$2 -h $5 --port=$6 -D $3 -e "drop table if exists log_validator_backup"
  20 else
  21 # If dumping fails, then restore the previous state
  22 mysql -u $1 -p$2 -h $5 --port=$6 -D $3 -e  "drop table if exists log_comment_encrypt"
  23 mysql -u $1 -p$2 -h $5 --port=$6 -D $3 -e "rename table log_comment_encrypt_backup to log_comment_encrypt"
  24 mysql -u $1 -p$2 -h $5 --port=$6 -D $3 -e  "drop table if exists log"
  25 mysql -u $1 -p$2 -h $5 --port=$6 -D $3 -e "rename table log_backup to log"
  26 mysql -u $1 -p$2 -h $5 --port=$6 -D $3 -e  "drop table if exists log_validator"
  27 mysql -u $1 -p$2 -h $5 --port=$6 -D $3 -e "rename table log_validator_backup to log_validator"
  28 fi