a guest Apr 17th, 2018 63 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- for database in $(mysql -u root -h $DB_HOST -p -A -N -B -e "SHOW DATABASES")
- echo -e "DATABASE: $database"
- for table in $(mysql -u root -h $DB_HOST -p -A -N -B -e "SHOW TABLES" $database)
- SHOW="SHOW TABLE STATUS IN $database LIKE '$table';"; SQL_STRING=$SQL_STRING$SHOW
- echo -e $SQL_STRING
- mysql -u root -h $DB_HOST -p -A -N -B -e "$SQL_STRING"
RAW Paste Data