Skip to content

Instantly share code, notes, and snippets.

@dgeske

dgeske/mysqldump-all

Created March 1, 2013 16:00
Show Gist options
  • Save dgeske/5065588 to your computer and use it in GitHub Desktop.
Save dgeske/5065588 to your computer and use it in GitHub Desktop.
Download ZIP
Backup All MySQL Databases into Individual Gzipped Files in Current Directory
Raw
mysqldump-all
for db in $(mysql -e 'show databases' -s --skip-column-names); do mysqldump $db | gzip > "$db-$(date +%Y-%m-%d).sql.gz"; done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment