Shell Script To Dump All MySQL Databases Every Hour To NAS Storage

+ Download this script
+ Modify settings according to your setup
+ Install cron job as follows to run script every hour

# Backup database every 1 hr to /nas 


@hourly /root/scripts/db1hr.backup.sh >/dev/null 2>&1

Sample Shell Script To Dump All MySQL Databases

#!/bin/bash


# A simple shell script to backup all MySQL Server Database


# Dump all MySQL database every hour from raid10 db disk to /nas/mysql


# Each dump will be line as follows:


# Directory:  /nas/mysql/mm-dd-yyyy 


# File: mysql-DBNAME.04-25-2008-14:23:40.gz


# Full path: /nas/mysql/mm-dd-yyyy/mysql-DBNAME.04-25-2008-14:23:40.gz 


# -------------------------------------------------------------------------


# Copyright (c) 2005 nixCraft project <http://cyberciti.biz/fb/>


# This script is licensed under GNU GPL version 2.0 or above


# -------------------------------------------------------------------------


# This script is part of nixCraft shell script collection (NSSC)


# Visit http://bash.cyberciti.biz/ for more information.


# -------------------------------------------------------------------------


# Last updated: Jul-16-2009 - Fixed a small bug


#       - Make sure NAS really mounted on $NAS


# -------------------------------------------------------------------------


NOW=$(date +"%m-%d-%Y") # mm-dd-yyyy format


FILE=""   # used in a loop


NASBASE="/nas"  # NAS Mount Point 


BAK="${NAS}/mysql/${NOW}" # Path to backup dir on $NAS


 


### Server Setup ###


#* MySQL login user name *#


MUSER="root"


 


#* MySQL login PASSWORD name *#


MPASS="YOUR-PASSWORD"


 


#* MySQL login HOST name *#


MHOST="127.0.0.1"


 


#* MySQL binaries *#


MYSQL="$(which mysql)"


MYSQLDUMP="$(which mysqldump)"


GZIP="$(which gzip)"


 


# Make sure nas is really mounted 


mount | awk '{ print $3}' |grep -w $NASBASE >/dev/null 


if [ $? -ne 0 ] 


then


 echo "Error: NAS not mounted at $NASBASE, please mount NAS server to local directory and try again."


 exit 99


fi


 


### NAS MUST BE MOUNTED in Advance ###


# assuming that /nas is mounted via /etc/fstab 


if [ ! -d $BAK ]; then


  mkdir -p $BAK


else


 :


fi


 


# get all database listing


DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')"


 


# start to dump database one by one


for db in $DBS


do


 FILE=$BAK/mysql-$db.$NOW-$(date +"%T").gz


 # gzip compression for each backup file


 $MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS $db | $GZIP -9 > $FILE


done

Shell Script To Delete Files In The First Directory Which Are Similarly Named In The Second Directory

A shell script to compare files in two directory and delete files in the first directory which are similarly named in the second directory. Following script uses for loop to compare files in a each directory.

#!/bin/bash


# Write a shell script that accepts two directory names as arguments and 


# deletes those files in the first directory which are similarly named in


# the second directory. 


SRC="$1"


DST="$2"


if [ $# -ne 2 ]


then


        echo "$(basename $0) dir1 dir2"


        exit 1


fi


 


if [ ! -d $SRC ]


then


        echo "Directory $SRC does not exists!"


        exit 2


fi


 


 


if [ ! -d $DST ]


then


        echo "Directory $DST does not exists!"


        exit 2


fi


 


for f in $DST/*


do


#echo Processing $f


        if [ -f $f ]


        then


                tFile="$SRC/$(basename $f)"


                if [ -f $tFile ]


                then


                        echo -n "Deleting $tFile..."


                        /bin/rm $tFile


                        [ $? -eq 0 ] && echo "done" || echo "failed"


 


                fi


        fi


done

Change password shell script

#!/usr/local/bin/expect -f


# Password change shell script, tested on Linux and FreeBSD


# ----------------------------------


# It need expect tool. If you are using Linux use following command


# to install expect


# apt-get install expect


# FreeBSD user can use ports or following command:


# pkg_add -r -v expect


# ----------------------------------


# If you are using linux change first line


# From:


#!/usr/local/bin/expect -f


# To:


#!/usr/bin/expect -f


# -----------------------------------------------


# Copyright (c) 2006 nixCraft project 


# This script is licensed under GNU GPL version 2.0 or above


# -------------------------------------------------------------------------


# This script is part of nixCraft shell script collection (NSSC)


# Visit http://bash.cyberciti.biz/ for more information.


# -------------------------------------------------------------------------


# display usage


if {$argc!=2} {


   send_user "usage: $argv0 username password \n"


   exit


}


# script must be run by root user


set whoami [exec id -u]


if {$whoami!=0} {


   send_user "You must be a root user to run this script\n"


   exit


}


#


set timeout -1


match_max 100000


# stopre password


set password [lindex $argv 1]


# username


set user [lindex $argv 0]


# opem shell


spawn $env(SHELL)


# send passwd command


send -- "passwd $user\r"


expect "assword:"


send "$password\r"


expect  "assword:"


send "$password\r"


send "\r"


expect eof

Shell script for search for no password entries and lock all accounts

#!/bin/bash


# Shell script for search for no password entries and lock all accounts


# -------------------------------------------------------------------------


# Copyright (c) 2005 nixCraft project <http://cyberciti.biz/fb/>


# This script is licensed under GNU GPL version 2.0 or above


# -------------------------------------------------------------------------


# This script is part of nixCraft shell script collection (NSSC)


# Visit http://bash.cyberciti.biz/ for more information.


# -------------------------------------------------------------------------


# Set your email 


ADMINEMAIL="admin@somewhere.com"


 


### Do not change anything below ###


#LOG File


LOG="/root/nopassword.lock.log"


STATUS=0


TMPFILE="/tmp/null.mail.$$"


 


echo "-------------------------------------------------------" >>$LOG


echo "Host: $(hostname),  Run date: $(date)" >> $LOG


echo "-------------------------------------------------------" >>$LOG


 


# get all user names


USERS="$(cut -d: -f 1 /etc/passwd)"


 


# display message


echo "Searching for null password..."


for u in $USERS


do


  # find out if password is set or not (null password)


   passwd -S $u | grep -Ew "NP" >/dev/null


   if [ $? -eq 0 ]; then # if so 


     echo "$u" >> $LOG 


     passwd -l $u #lock account


     STATUS=1  #update status so that we can send an email


   fi  


done


echo "========================================================" >>$LOG 


if [ $STATUS -eq 1 ]; then


   echo "Please see $LOG file and all account with no password are locked!" >$TMPFILE


   echo "-- $(basename $0) script" >>$TMPFILE


   mail -s "Account with no password found and locked" "$ADMINEMAIL" < $TMPFILE


#   rm -f $TMPFILE


fi

Shell Script To Read IP Address ( Find Ip Address Script )

#!/bin/sh


# Shell script scripts to read ip address


# -------------------------------------------------------------------------


# Copyright (c) 2005 nixCraft project <http://cyberciti.biz/fb/>


# This script is licensed under GNU GPL version 2.0 or above


# -------------------------------------------------------------------------


# This script is part of nixCraft shell script collection (NSSC)


# Visit http://bash.cyberciti.biz/ for more information.


# -------------------------------------------------------------------------


# Get OS name


OS=`uname`


IO="" # store IP


case $OS in


   Linux) IP=`ifconfig  | grep 'inet addr:'| grep -v '127.0.0.1' | cut -d: -f2 | awk '{ print $1}'`;;


   FreeBSD|OpenBSD) IP=`ifconfig  | grep -E 'inet.[0-9]' | grep -v '127.0.0.1' | awk '{ print $2}'` ;;


   SunOS) IP=`ifconfig -a | grep inet | grep -v '127.0.0.1' | awk '{ print $2} '` ;;


   *) IP="Unknown";;


esac


echo "$IP" 

Shell Script To Monitor Services Such As Web / Http, Ssh, Mail Server

#!/bin/bash


# Shell script to monitor running services such as web/http, ssh, mail etc. 


# If service fails it will send an Email to ADMIN user


# -------------------------------------------------------------------------


# Copyright (c) 2006 nixCraft project <http://www.cyberciti.biz/fb/>


# This script is licensed under GNU GPL version 2.0 or above


# -------------------------------------------------------------------------


# This script is part of nixCraft shell script collection (NSSC)


# Visit http://bash.cyberciti.biz/ for more information.


# ----------------------------------------------------------------------


# See URL for more info


# http://www.cyberciti.biz/tips/processing-the-delimited-files-using-cut-and-awk.html


# ---------------------------------------------------


# Last updated: Jun - 15 - 2009.


ports="22 53 80 25"


 


# service names as per above ports


service="SSH DNS WEB MAIL"


 


#Email id to send alert


ADMINEMAIL="admin@myispname.com"


 


#Bin paths, set them according to your Linux distro 


NETSTAT=/bin/netstat


MAIL=/usr/bin/mail


LOGGER=/usr/bin/logger


ID=/usr/bin/id


 


# Red hat usr uncomment 


MAIL=/bin/mail


LOGGER=/bin/logger


 


 


#Counters, set defaults


c=1


status=""


sendmail=0


 


# set the following to 1, if you want message in /var/log/messages via a SYSLOG


logtosyslog=0


 


# Log file used to send an email


LOG="/tmp/services.log.$$"


 


# log message to screen and a log file


log(){


 echo "$@"


 echo "$@" >> $LOG


}


 


# log message and stop script


die(){


 echo "$@"


 exit 999


}


 


# Make sure only root can run it


is_root(){


 local id=$($ID -u)


 [ $id -ne 0 ]  && die "You must be root to run $0."


}


# Look out for all bins and create a log file


init_script(){


 [ ! -x $MAIL ] && die "$MAIL command not found."


 [ ! -x $NETSTAT ] && die "$NETSTAT command not found."


 [ ! -x $LOGGER ] && die "$LOGGER command not found."


 [ ! -x $ID ] && die "$ID command not found."


 is_root


 >$LOG


}


 


 


# check for all running services and shoot an email if service is not running


chk_services(){


 log "-------------------------------------------------------------"


 log "Running services status @ $(hostname) [ $(date) ]"


 log "-------------------------------------------------------------"


 


 # get open ports 


 RPORTS=$($NETSTAT -tulpn -A inet | grep -vE '^Active|Proto' | grep 'LISTEN' | awk '{ print $4}' | cut -d: -f2 | sed '/^$/d' | sort  -u)


 


 # okay let us compare them


 for t in $ports


 do


  sname=$(echo $service | cut -d' ' -f$c)


  echo -en " $sname\t\t\t : "


  echo -en " $sname\t\t\t : " >> $LOG


  for r in $RPORTS


  do


   if [ "$r" == "$t" ]


   then


    status="YES" 


    sendmail=1


    break


   fi


  done


  echo -n "$status"


  echo ""


  echo -n "$status" >>$LOG


  echo "" >>$LOG


  # Log to a syslog /var/log/messages?


  # This is useful if you have a dedicated syslog server


  [ $logtosyslog -eq 1  ] && $LOGGER "$sname service running : $status"


 


  # Update counters for next round


  c=$( expr $c + 1 )


  status="NO"


 done


 log "-------------------------------------------------------------"


 log "This is an automatically generated $(uname) service status notification by $0 script."


 


 if [ $sendmail -eq 1 ];


 then


  $MAIL -s "Service Down @ $(hostname)" $ADMINEMAIL < $LOG


 fi


}


 


### main ###


init_script


chk_services


 


### remove a log file ###


[ -f $LOG ] && /bin/rm -f $LOG