Faster mysql dump import (innodb) & database size checks

gistfile1.txt

(echo "SET autocommit=0; SET unique_checks=0; SET foreign_key_checks=0;"; cat database_name.sql ; echo "COMMIT;" ) | mysql database_name

# in /etc/my.cnf set:
#   innodb_flush_log_at_trx_commit = 2 
#   innodb_file_per_table

# check size of databases:
#SELECT table_schema AS "Data Base Name", 
#ROUND(SUM( data_length + index_length ) / 1024 / 1024, 2) AS "Data Base Size in MB" 
#FROM information_schema.TABLES GROUP BY table_schema ;

# check table sizes:
#SELECT TABLE_NAME, table_rows, data_length, index_length,
#round(((data_length + index_length) / 1024 / 1024),2) "Size in MB"
#FROM information_schema.TABLES WHERE table_schema = "database_name";