restore.bash 405 B

1234567891011121314151617181920
  1. #!/bin/bash
  2. set -e
  3. DBNAME="mastostart"
  4. basedir=$(dirname "$0")
  5. cd "${basedir}/backups"
  6. xzfp=`ls -1 --time=birth -r *.xz 2>/dev/null | tail -n 1 2>/dev/null`
  7. sqlfp=$(basename -s .xz "${xzfp}")
  8. if [ -z "${xzfp}" ]; then
  9. echo "No backup found :-(" 1>&2
  10. else
  11. echo "Uncompressing most recent backup file: «${xzfp}» ..."
  12. xz -dk $xzfp
  13. mariadb -u root -p "${DBNAME}" < "$sqlfp"
  14. rm "${sqlfp}"
  15. fi
  16. exit 0