Last Updated: February 25, 2016
·
1.243K
· mackittipat

MySQL import progress bar

From http://www.commandlinefu.com/commands/view/10185/progress-bar-for-mysql-import

pv -petli 1 {FILE.sql} | mysql -u{USER} -p{PASS} {DBNAME}

From http://dba.stackexchange.com/questions/17367/how-can-i-monitor-the-progress-of-an-import-of-a-large-sql-file

SELECT table_schema "DB Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" 
FROM information_schema.TABLES GROUP BY table_schema;