title: “Mysqldump seperate files”
date: 2019-08-13T15:14:46
slug: mysqldump-seperate-files

mysql -N -e 'show databases' | while read dbname; do mysqldump --complete-insert --routines --triggers --single-transaction "$dbname" > "$dbname".sql; [[ $? -eq 0 ]] && gzip "$dbname".sql; done