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**

<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)