]>
code.delx.au - monosys/blob - backup-mysql
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"
12 rm -f $
(ls -1 "${db}-"* |
sort -r |
tail -n +10)