Dumps all mysql databases in separate files

mysql_dump_separate_files.sh

# Don't forget to replace **USER** and **PASS** twice.

# https://explainshell.com/explain?cmd=mysql+-s+-r+-u**USER**+-p**PASS**+-e+%27show+databases%27+-N+%7C+while+read+dbname%3B+do+mysqldump+-u**USER**+-p**PASS**+--complete-insert+--single-transaction+%22%24dbname%22+%3E+%22%24dbname%22.sql%3B+done

mysql -s -r -u**USER** -p**PASS** -e 'show databases' -N | while read dbname; do mysqldump -u**USER** -p**PASS** --complete-insert --single-transaction "$dbname" > "$dbname".sql; done