Featured
MySQL Back-up: mysqldump with each database in its own SQL File
Take a mysqldump back-up to separate files To take a back-up, run the mysqldump tool on each available database. $ mysql -N -e 'show databases' | while read dbname; do mysqldump --complete-insert --routines --triggers --single-transaction "$dbname" > "$dbname".sql; doneThe result is a list of all