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**
<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
innobackupx_scripted_to_backup_daily.1299028759.txt.gz · Last modified: 2020/08/10 02:30 (external edit)