]>
code.delx.au - monosys/blob - backup-mysql
fa860568375d12e62d185f08b0dba6e344cdbd8b
3 DATABASES
="$(echo 'show databases' | mysql | tail -n+2)"
7 for db
in ${DATABASES}; do
8 mysqldump
--add-drop-table --single-transaction "${db}" | \
9 gzip -9 > "${db}-$(date '+%Y%m%d').sql.gz"
11 rm -f $
(ls -1 "${db}-"* |
sort -r |
tail -n +10)