$ mysqladmin ping|status|version|processlist|variables|shutdown|create db|drop db ...

$ mysqlshow [db [table [column]]]   -i other info

**********************

# export resultset to shell:
$ mysql db1 -e "select * from t1"   Output format: -B (no borders)
  (CMD doesn't allow ' ?)                         -H (html table)  -X (xml)
$ mysql -e "use menagerie;select * from pet;"
#redirect output to file:
$ mysql -e "select ....." >outfilename   

tee tooutfile    Log interactive to file  (like typescript in shell)
...               all this being copied to the totoutfile
notee            Stop the logging


**********************
backup a db to a text file (creates a SQL script file of Create Table and Inserts)
#one or more tables from one database:
$ mysqldump   db [tablenames]   >dumpfile.sql    #structure and data

Can restore by:
$ mysql dbname  <dumpfile.sql    #assuming dbname has been created already
OR
  create database dbname;
  use dbname 
  source dumpfile     OR    \. dumpfile
 OR:
$ mysql -e "source dumpfile"  #assuming dbname has been created already
OR
$ mysql -e "create database dbname;use dbname;source dumpfile" 
OR: 
 edit the dump file and prepend:
   create database if not exists dbname;
   use dbname;
 then: mysql dbname <dumpfile   OR mysql -e "source dumpfile"

Copy a database from here to there:
$mysqldump --opt db | mysql -h there db