When importing a large MySQL dump file, use pv to monitor the progress of data through a pipe:
pv -petr dumpfile.sql | mysql -uroot my_database
This will give you a progress indicator such as:
0:00:05 [3.63MB/s] [===> ] 0% ETA 0:09:41
{ 2011 03 08 }
Post a Comment