This shows you the differences between two versions of the page.
innobackupx_scripted_to_backup_daily [2011/03/02 01:19] k2patel created |
innobackupx_scripted_to_backup_daily [2020/08/10 02:35] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== 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 | ||