Backup all mysql databases in separate files - fourslickz/notes GitHub Wiki

mysql -N -e 'show databases' | while read dbname; do mysqldump --complete-insert --routines --triggers --single-transaction "$dbname" > "$dbname".sql; done