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: 2020/08/10 02:30 (external edit)