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}
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;
Written by MacKittipat
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Mysql
Authors
Related Tags
#mysql
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#