backup-nout-flyspray-on-gouza7

   1 #!/bin/sh
   2 #
   3 # backup mysql database
   4
   5 BACKUP_FILE_NAME=nout-flyspray-daily.sql.gz
   6 DATABASE=flyspray
   7 DB_HOST=localhost
   8 DB_USER=root
   9 DB_PASSWORD=""
  10 REMOTE_BACKUP_DIR="backup@55.55.55.20:/var/backups/"
  11
  12 LOCAL_BACKUP_DIR=/var/backups/
  13
  14 /usr/bin/mysqldump -h $DB_HOST -u $DB_USER --password=$DB_PASSWORD $DATABASE | /bin/gzip -c > $LOCAL_BACKUP_DIR/$BACKUP_FILE_NAME
  15 /usr/bin/scp $LOCAL_BACKUP_DIR/$BACKUP_FILE_NAME $REMOTE_BACKUP_DIR