How to create SQL dumps of all user’s MySQL databases

September 8, 2018 at 10:57 pm (last edited September 8, 2018 at 11:36 pm)

Enter username and wait while it creates MySQL dumps:

read -p "Username: "user && for i in `mysqlshow |grep $user |cut -d '|' -f2`; do mysqldump $i > $i.sql; done