SHARE
TWEET

Untitled




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