How to create SQL dumps of all user’s MySQL databases
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… Read the rest
Notes
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… Read the rest