Monitoring MySQL Import Progress
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