This is an old revision of the document!
* 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.
<code bash | /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