Daily *Nix

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== XtraBackup ======

Nice tool to create Hot Backup.\\
[[https://launchpad.net/percona-xtrabackup | Project Page]]

<code bash>
#!/bin/bash

today=`date +%Y%m%d`
yesterday=`date -d 'now -2 days' +%Y%m%d`

if [ ! -d /usr/new_db_backup/$today ]; then

        if /usr/bin/innobackupex-1.5.1 --defaults-file=/etc/my.cnf --tmpdir=/tmp --user=root --password=TestDrive --no-timestamp  /usr/new_db_backup/$today
        then
                echo "Backup completed Successfully Location /usr/new_db_backup/$today" | mail -s "[BACKUPS] `hostname` " ketan@email.com
                /bin/rm -rf /usr/new_db_backup/$yesterday
                exit 0
        else
                echo "The xtrabackup did not complete successfully." | mail -s "[BACKUPS] `hostname` " ketan@email.com
                exit 1
        fi
else
        echo "Directory exists might be second run please check" | mail -s "[BACKUPS] `hostname` " ketan@email.com
        exit 1
fi
</code>

Daily *Nix

User Tools

Site Tools

Page Tools