#!/bin/sh

read -p "Customer box hostname: " BOX    # set variable to customer box hostname
mkdir -p /var/log/backups
mysqldump backups > /var/log/backups/backups.$(date +%s).sql  # backup database
mysql backups -e "select * from pubkeys where serverid=(select serverid from server where hostname = '$BOX')\G"
read -p "Remove? y/n " ANSWER
if [[ $ANSWER =~ "y" ]] ; then
  mysql backups -e "delete from pubkeys where serverid=(select serverid from server where hostname = '$BOX') limit 1"
  echo "Removed"
else
  echo "Exiting"
fi
exit  # we're done with backupmaster

