User Tools

Site Tools


innobackupx_scripted_to_backup_daily

This is an old revision of the document!


InnoBackupX

* This is great tool for hot online backup.
* Following script is used to backup mysql to remote server with key less entry only.
* Following script need you to change some variables.

**Master server**
| /usr/bin/pushbackup.sh
#!/bin/bash
 
if /usr/bin/innobackupex-1.5.1 --no-timestamp --no-lock --user=root --password=testpassword --stream=tar ./ | ssh root@remote.backup.com "cat - > /root/bkuptest/Backup/test.tar"
then
        if ssh root@remote.backup.com "/usr/local/bin/mybackup.sh"
                then
                echo "Backup Done" | mail -s "[Backup] backup done Complete" ketan@email.com
        else
                echo "Backup Failed" | mail -s "[Backup] master Failed" ketan@email.com
        fi
else
        echo "Backup Failed" | mail -s "[Backup] master Failed" ketan@email.com
fi
innobackupx_scripted_to_backup_daily.1299028773.txt.gz · Last modified: 2011/03/01 20:19 by k2patel