Mysql database backup script

HI, 
  AutoMySQLBackup with a basic configuration will create Daily, Weekly and Monthly backups of one or more of your MySQL databases from one or more of your MySQL servers.
I am using a script to take a backup of all my databases in the Mysql. After that it will auto move backup to NAS storage.



[root@phpMyfaq ~]# cat /root/Scripts/DB_Backup
#!/bin/bash
##
##This script will take the backup of all
##Database of this server
##
##
######## MYSQL SETUP BACKUP #####
MUSER="root"
MPASS="redhat"
MHOST="localhost"
MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
BACKUP="/root/Backup/DB/"
GZIP="$(which gzip)"
NOW=$(date +"%d-%m-%Y")

### Other stuff ###
EMAILID="support@example.com"

##################################

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

for db in $DBS;
do
        FILE=$BACKUP/$NOW-$db.gz
        $MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS $db > $BACKUP/$NOW-$db.sql
        $GZIP $BACKUP/$NOW-$db.sql
done

##### DUMPING BACKUP USING RSYNC #####
##### Where 172.20.1.30 IP address of NAS
  rsync -avz $BACKUP/* 172.20.1.30:/backup/10.125.1.240/db/

##### FIND OUT IF RSYNC BACKUP FAILED OR not ######
if [ "$?" == "0" ]; then
 mv  $BACKUP/* /root/LASTBKP/DB/
 else
 T=/tmp/backup.fail
 echo "Date: $(date)" >$T
 echo "Hostname: $(hostname)" >>$T
 echo "DATA BASE Backup Failed" >>$T
 mail -s "DB Backup Failed $Hostname" "$EMAILID" <$T
 rm -f $T
fi

Comments

  1. MySQL Database Backup ScriptApril 28, 2018 at 5:55 AM

    Nice blog. Here is the best MySQL database backup script I found. Thanks for sharing valuable content.

    ReplyDelete

Post a Comment

Thank you for visiting my blog.

Popular posts from this blog

Defining Audit Rules

The Audit system operates on a set of rules that define what is to be captured in the log files. There are three types of Audit rules that can be specified: Control rules — allow the Audit system's behavior and some of its configuration to be modified. File system rules — also known as file watches, allow the auditing of access to a particular file or a directory. System call rules — allow logging of system calls that any specified program makes.  Audit rules can be specified on the command line with the auditctl utility (note that these rules are not persistent across reboots), or written in the /etc/audit/audit.rules file. The following two sections summarize both approaches to defining Audit rules.   Auditing goals By using a powerful audit framework, the system can track many event types to monitor and audit the system. Examples include: Audit file access and modification See who changed a particular file Detect unauthorized cha...
Read more

AIX Install packages, upgrade, patching commands

lslpp -L                             displays info about all installed filesets or fileset updates lslpp -L <fileset>                   displays info about that fileset lslpp -h <fileset>                   shows the history of the fileset lslpp -l | grep <fileset>           shows if it is installed or not lslpp -lc| grep <fileset>           shows the state (Aplp., Comm., Broken..) in /etc/objrepos and in /usr/lib/objrepos of a fileset lslpp -f <fileset>                   shows all files that are installed with  a particular fileset lslpp -w /usr/local/bin/lsof        shows the fileset which contains the giv...
Read more

Oracle Database Quick Installation steps 11g Release 2 for Linux x86-64

This article is a comprehensive steps for installing Oracle Database 11 g Release 2 (11.2.0.1) on the Red Hat Enterprise Linux 6 (RHEL6)  operating environment. Both 32-bit (x86) and 64-bit (x86_64) architectures are covered in this guide. Unless otherwise noted, the installation steps are the same for either. Having said that, one of the first decisions to make before continuing with this guide is which architecture you will be using. Both Oracle and Linux must be installed on the same operating system architecture. For example, 32-bit Oracle is only supported to run on 32-bit Linux OS and 64-bit Oracle is only supported to run on 64-bit Linux OS. Install Required Linux Packages for Oracle: After installing the Linux OS, the next step is to verify and install all packages required for Oracle Database 11 g Release 2. The Oracle Universal Installer (OUI) performs checks on the machine during installation to verify that it meets the...
Read more