code.delx.au - monosys/blob - backup-mysql

   1 #!/bin/bash
   2
   3 set -eu
   4
   5 cd ~/backup-mysql/
   6
   7 DATABASES="$(echo 'show databases' | mysql | grep -vE '^(Database|mysql|information_schema|performance_schema)$')"
   8 for db in ${DATABASES}; do
   9     mysqldump --add-drop-table --single-transaction "${db}" | \
  10         gzip -9 > "${db}-$(date '+%Y%m%d').sql.gz"
  11
  12     rm -f $(ls -1 "${db}-"* | sort -r | tail -n +10)
  13 done