mysql -h HOST -u USUARIO -p PASSWORD

  show databases;
  use BD;

  show tables;
  describe TABLA;

  SELECT User, Host FROM mysql.user;
  DROP USER 'nombre_usuario'@'localhost';

  status
  show variables;
  show variables like '%max%';

  create database qrevisa;
  grant all on qrevisa.* TO data@localhost;
  grant all on qrevisa.* to wwwrun@localhost;
  
  create database wordpress;
  grant all on wordpress.* to 'wordpress_user'@'localhost' identified by 'XXXXX';
  flush privileges;

  mysqldump -u xxxx -p xxxx --no-data -d BASEDATOS >dump.sql

  mysqldump -u xxxx -p xxxx --add-drop-table --no-data -d BASEDATOS |grep ^DROP >borrado.sql

  show create table TABLA;
  SELECT table_schema,TABLE_NAME, ENGINE FROM information_schema.TABLES;
  ALTER TABLE TABLA ENGINE = InnoDB;

  export MYSQL_PS1="mysql://\u@\h:/\d - \R:\m:\s > "

  mysql -umysqlusername -pmysqlpass databsename -B \
  -e "select * from \''tabalename\'';" | \
  sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > mysql_exported_table.csv

  mysql -e 'show databases' | sed -n '2,$p' | xargs -I DB 'mysqldump DB > DB.sql'

  mysqlcheck -a --auto-repair -c -o -uroot -p [DB]

  mysqldump OLD_DB | cat <(echo "CREATE DATABASE NEW_DB; USE NEW_DB;") - | mysql

(pv -n ~/database.sql | mysql -u root -pPASSWORD -D database_name) 2>&1 

  pv -i 1 -p -t -e /path/to/sql/dump | mysql -u USERNAME -p DATABASE_NAME

  SELECT '<info_to_display>' AS ' ';

En un fichero de texto, usando TAB como separador

  SELECT order_id,product_name,qty
  FROM orders
  INTO OUTFILE '/tmp/orders.txt'

En un fichero CSV (con puntos y comas)

  SELECT order_id,product_name,qty
  FROM orders
  INTO OUTFILE '/tmp/orders.csv'
  FIELDS TERMINATED BY ';'
  ENCLOSED BY '"'
  LINES TERMINATED BY '\n'

Alternativa cuando mysql no tiene permiso FILE (lo anterior da error)

  echo 'select * from sometable into outfile' | mysql -p -u someuser somedatabase > /tmp/output

Grabar toda la sesion en un fichero

  tee session.out

  mysqldump -u qrevisa --password=xxxxxx --opt --quote-names --skip-set-charset --default-character-set=latin1 qrevisa >dump.sql
  mysql --database=dbname 'ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_spanish_ci;'
  ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_spanish_ci;
  mysql --database=dbname -B -N -e "SHOW TABLES" | \
  awk '{print "ALTER TABLE", $1, "CONVERT TO CHARACTER SET utf8 COLLATE utf8_spanish_ci;"}' | \
  mysql --database=dbname &
  mysql --default-character-set=utf8 <dump.sql

  describe TABLA;
  select table_name,engine,table_rows,avg_row_length,data_length
    from information_schema.tables where table_schema='qrevisa';
  select format(sum(data_length)/1024/1024,2) as Mb
    from information_schema.tables;
  select * from information_schema.tables;